UserForm Creation

gtd526

New Member
Joined
Jul 30, 2013
Messages
26
Platform
Windows
I'm have trouble with #3....

We are now going to create the Sub UserForm_Initialize. When you use the Show method for the Userform, this sub will automatically be executed.
1. Open the Visual Basic Editor. (fine, can do)
2. In the Project Explorer, right click on DinnerPlannerUserForm and then click View Code. (fine, can do)
3. Choose Userform from the left drop-down list. Choose Initialize from the right drop-down list. (problem, can't do)
4. Add the following code lines:

#3...where is the left drop-down list and where is the right drop-down list?
I don't know where they are.
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,095,734
Messages
5,446,191
Members
405,390
Latest member
RafalKowalski

This Week's Hot Topics

Top