Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Failed userform loading and cause application crash | Excel Programming | |||
Loading graphic into top left strip of userform | Excel Programming | |||
Loading UserForm gives error | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Loading UserForm on start up. | Excel Programming |