Showing User Form in a Custom Module

Dear Ms Expert.

MyUserForm.Show

The above code works in a worksheet code section but not in a custom Module? Why? How can I make this call outside of the Worksheet section.

Thanks.

Peter.

Hello Peter,

If by "custom module" you mean a standard VBA Module then the answer is yes the code will run from here. You will need to create a Sub procedure and place the code in it. You can then call the macro using ALT+F8 or from other code routines.

Example

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

Sincerely,
Leith Ross

grrr ..... my subroutine's name was the same as my UserForm.

Thanks