Jay has attended:
Excel Intermediate course
Excel Advanced course
UserForm
On a user form i have 2 questions.
Is there a quick way to call it?
I.E for my other marco's i have CTRL + A ect...
when i go to :
Developer
Macros
Select the One
Options
ShortCut Key
I would like to do this for my user form i have created how would i do this?
at the top of the marco its
Sub cmdCloseForm_Click()
Unload Me
End Sub
if this helps.
Also is it possible to have a text box come up after the userform is run as a reminder to do something? I know you can on a normal macro.
Regards
Jay
RE: UserForm
Hi Jay
To start the form with a button or shortcut key you'll have to create a separate macro in a normal module, for example
Sub StartForm
FormName.Show
End Sub
(where FormName is the name of your user form).
You can then assign a shortcut key to the StartForm macro from Macros, Options
To add a textbox after the form is run
Add the line
Msgbox "Please complete this form then press ok"
before FormName.Show
Hope that works on your form.
Regards
Doug
Best STL
