Open form with condition

[adamsm]

Hi anyone,

How could I write a macro code that on click would open the user form1, place the text in cell M10 on textbox1 and check the optionbutton1 and would click the button Next on load.

Is there a way I could place the code in standard module instead of the form module?

I hope I have made my question clear.

Thanks in advance.

 

[Norie]

Well you could have all the code in a module, but populating the textbox, checking the optionbutton etc would probably be best kept in the userform module.

To open the form on the click of a button just add one to a worksheet.

Then either double click it or select it, right click and select Assign macro...

If you double clicked you should then see something like this.

Option Explicit
 
Private Sub CommandButton1_Click()
 
End Sub

If you used Assign macro the Macro dialog will appear.

Click New on that and you'll see something like this.

Option Explicit
 
Sub Button1_Click()
 
End Sub

Whichever you see just add this code to show the userform.

UserForm1.Show

Change UserForm1 to the name of your form.

 

[adamsm]

Thanks for the help.