Macro view not showing Userform macro

[Metaripley]

Ive got a userform which runs if i press the play button within VBA.
But I want to connect it to a button on the worksheet.
And in the macro vieuw list it is not showing.
The code is in the Userform code.
Removing the "Private" dosnt work.

Private Sub UserForm_Initialize()




End Sub




Private Sub CommandButton2_Click()


' Hide the Userform and set cancelled to true
    Hide
    m_Cancelled = True


End Sub

 

[RoryA]

Re: Macr vieuw not showing Userform macro

To show a userform you should have another routine that looks something like this:

Sub ShowMyForm()
Userform1.Show
End Sub

and assign that to your button.

 

[James_Latimer]

Re: Macr vieuw not showing Userform macro

You need to call the userform from another routine...

Sub OpenMyForm

MyFormName.Show

End Sub

Then link your button to the OpenMyForm routine

 

[My Aswer Is This]

Re: Macr vieuw not showing Userform macro

You should have a script like this in your button:

UserForm1.Show

The initialize code goes in the Userform and runs when the UserForm opens.

 

[Metaripley]

Re: Macr vieuw not showing Userform macro

Thanks!

 

[My Aswer Is This]

Re: Macr vieuw not showing Userform macro

Thanks!

Not sure which answer helped you but:
Glad we were able to help you.
Come back here to Mr. Excel next time you need additional assistance.