Another form problem

[robh0409]

hi there


i am looking at using a button on the home page of my work book and wanted one to open a form that i have created but cannot figure out the syntax for it.

so far i have this

[pre]

Public Sub callform()
openform
End Sub
and this

Public Sub callform()
Run ("UserForm_Initialize")
End Sub

[/pre]
any ideas?


Rob

 

[Luke M]

The line is:

UserForm1.Show

The initialize macro would be within the UserForm1 module.

 

[Hui]

Rob


Sub OpenMyUserform()

UserForm1.Show

End Sub


On opening the Userform Initialise routine will execute and this is where you should set all the userforms default control values


Secondly, there is no need to post two similar questions here.

So I have deleted the other post and shifted my response here, even though it is the same as Lukes