How to Get a Drop-Down Box in VBA

Visual Basic for Applications or VBA is a Microsoft-designed, event-driven programming language used for creating applications, automating processes and for creating menus, toolbars and interactive elements. Drop-down boxes can offer an efficient way to add information to a page in a condensed format. Creating a drop-down box in VBA can be completed using an empty form and filling out the menu items through a series of prompts.

Instructions

1. Click the "Start" button and click "All Programs." Click "Microsoft Visual Studio" to launch the VBA application.

2. Click "File," "New Project" to open a new VBA project. Click "Installed Templates," then click "Other Languages," "Visual Basic" and "Windows." Click "Windows Forms Applications," then "OK" to open an empty form for creating your drop-down box.

3. Click the "Toolbox" and select the "Menu Strip." Drag the "Menu Strip" to your empty form. Prompts will display to enter the data for your drop-down box.

4. Type a name for first menu choice in the "Type Here" box. Continue to enter names for your menu components when prompted.

5. Click "Build," then "Build Solution" to create and view your drop-down box.

References

• Free Tutes: Working with Menus in Visual Basic
• MSDN: Creating a Menu