Building a data entry form with Excel VBA

[Pondering23]

Excel 2016, Windows 7.

I am trying to learn how to build a data entry form for a worksheet that contains more than 32 columns. When I searched the forum I found this post from someone with a similar question. Following that thread, I started working on the tutorial for Excel VBA Userform - Easy Excel Macros.

I followed the tutorial and successfully built the initial form with its various controls.

However, I hit a wall when I tried to sit up the 'Show the userform' portion of the tutorial. Per the tutorial, I:

1. opened the Visual Basic Editor
2. In the Project Explorer, right click on Dinner PlannerUSerForm and then click on View Code.

I hit a wall at:
3. Choose Userform from the left drop-down list. Choose initialize from the right drop-down list.

I can find the Userform from the left drop-down. However, I have been unable to find ANY right drop-down that has 'Initialize' as an option.

Suggestions?

Thanks for any guidance anyone can provide!

 

[Logit]

.
Show the form in the VBE just as you have done previously.

Right click on the form and select VIEW CODE.

Now look at the menu bar up top. There should be two drop downs. One on the
left says (GENERAL) and the on the right says (DECLARATIONS).

In GENERAL select USERFORM, in DECLARATIONS select INITIALIZE.

 

[Pondering23]

.
Show the form in the VBE just as you have done previously....

That did it! Ran through rest of tutorial for the form and it worked exactly as advertised.

Thanks for your help!

 

[Logit]

Great !