Launch form from an onscreen button

[Coppa]

I have developed a form and the macros behind it, but I would like to add a button to my excel page to launch the form. Forms don't seem to appear in the macro list when you assign a macro to a shape/ button. How do i link my form to by button?

 

[bjurney]

Do you mean something like this?

Private Sub CommandButton1_Click()
 UserForm1.Show
End Sub

 

[VoG]

You would need to assign a small macro to the button

Sub LaunchForm()
userform1.Show
End Sub