How can I load a user form from within a worksheet subroutine?

[Guest]

I can load it from a module or from a forms routine, but not from a worksheet
routine. I want to be able to have it load when a command button (residing
on the worksheet) is clicked.

 

[Guest]

Doug,

Place this behind the command button on the sheet

Private Sub CommandButton1_Click()
Load UserForm1
End Sub

 

[Guest]

It didn't work. I keep getting a run-time error code, "1004": Application
defined error.

 

[Guest]

JRForm,

I did get it to work. What I had to do was to include a call for a Load/Show
subroutine that I located in the Module. I can now Load/Show my UserForm.

Thank you all,
Doug

 

[Guest]

Doug,

The code I gave you should have worked if you placed it in the code module
for the button. However, I did assume you already had the UserForm1.
I am glad you have it working.