How to Create a Drop-Down on QuattroPro
- 1). Select the Tools menu.
- 2). Choose Visual Basic Editor.
- 3). Switch to Project View and double-click Global Macros.
- 4). Input "UserForm1" in the title text field followed by "CreateDropDownMenu."
- 5). Input "Public Sub CreatePlatform()" in the code box. Then type "Set myXp = CreateObject(name) Bracket(position)", where (name) is the label on the menu and (position) is its position (numbered one, two, three, etc.) relative to the other drop-down menus, from left to right.