Loading Userform
 

I am having some challenges on getting a command button to load and show a
user form

this is the code for the command button on each of the worksheets to load
and show the userform:

Private Sub CommandButton1_Click()
LoadForm
End Sub

this is the code for LoadForm which is located in a module.

Sub LoadForm()
Load UserForm1
UserForm1.Show
End Sub

I can't see why that I am getting an error message that indicates the
application-defined or object defined error.

Loading Userform
 

Change the "CommandButton1" to just "Button1".

It should work fine.

Brian



"Steven Cheng" wrote in message
...
I am having some challenges on getting a command button to load and show a
user form

this is the code for the command button on each of the worksheets to load
and show the userform:

Private Sub CommandButton1_Click()
LoadForm
End Sub

this is the code for LoadForm which is located in a module.

Sub LoadForm()
Load UserForm1
UserForm1.Show
End Sub

I can't see why that I am getting an error message that indicates the
application-defined or object defined error.

Loading Userform
 

Thanks for responding Brian. However, I changed the button name but it sill
came up with the same error message.

Is there something else that I am missing?

"Steven Cheng" wrote:

I am having some challenges on getting a command button to load and show a
user form

this is the code for the command button on each of the worksheets to load
and show the userform:

Private Sub CommandButton1_Click()
LoadForm
End Sub

this is the code for LoadForm which is located in a module.

Sub LoadForm()
Load UserForm1
UserForm1.Show
End Sub

I can't see why that I am getting an error message that indicates the
application-defined or object defined error.

Loading Userform
 

Remove "Load UserForm1". UserForm1.show will work to open the form.

If that doesn't work than you'll need to check the names of the button and
the userform. if you change those names the events and macros will no longer
work.

"Steven Cheng" wrote:

I am having some challenges on getting a command button to load and show a
user form

this is the code for the command button on each of the worksheets to load
and show the userform:

Private Sub CommandButton1_Click()
LoadForm
End Sub

this is the code for LoadForm which is located in a module.

Sub LoadForm()
Load UserForm1
UserForm1.Show
End Sub

I can't see why that I am getting an error message that indicates the
application-defined or object defined error.