UserForm

Resolved · High Priority · Version 2010

Wed 30 Jul 2014, 12:04 Delegate Jay said...

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

Wed 30 Jul 2014, 14:25 Trainer Doug said...

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