| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I load a user form from within a worksheet subroutine?
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I load a user form from within a worksheet subroutine?
Doug,
Place this behind the command button on the sheet Private Sub CommandButton1_Click() Load UserForm1 End Sub "Doug" wrote: 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I load a user form from within a worksheet subroutine?
It didn't work. I keep getting a run-time error code, "1004": Application
defined error. "JRForm" wrote: Doug, Place this behind the command button on the sheet Private Sub CommandButton1_Click() Load UserForm1 End Sub "Doug" wrote: 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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I load a user form from within a worksheet subroutine?
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 "JRForm" wrote: Doug, Place this behind the command button on the sheet Private Sub CommandButton1_Click() Load UserForm1 End Sub "Doug" wrote: 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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I load a user form from within a worksheet subroutine?
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. :) "Doug" wrote: 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 "JRForm" wrote: Doug, Place this behind the command button on the sheet Private Sub CommandButton1_Click() Load UserForm1 End Sub "Doug" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Form - how to load it | Excel Discussion (Misc queries) | |||
| worksheet subroutine causes Compile error: Not found when on User | Excel Programming | |||
| how to load chart in user form | Excel Programming | |||
| Conditional load of form when entering a certain worksheet | Excel Programming | |||
| Userform doesn't recognize other user form upon re-load | Excel Programming | |||
Linear Mode
