Getting Toolbars You Will Need

There are two "stock" Excel toolbars and one custom toolbar you will need during the project. The Forms toolbar is used to create user controls on the worksheet (see Forms Toolbar). The Drawing toolbar is used to access the Text Box item, used as a control object in this project, and auto-shapes, used as labels for the project. A custom Align toolbar (see Make and Use a Custom Align Toolbar ) is used to align control objects such as buttons and list boxes.

Open an Excel workbook and save it with a name like "Trip_Planner_01.xls".
Menu command View > Toolbars (or right-click any toolbar), and select the Forms toolbar.

Right-click and select the Drawing toolbar.

If you haven't done so already, follow the directions in the main course to create a custom Align Toolbar. You should include, at a minimum, the Align Left, Align Center, Align Middle, and Distribute Horizontally buttons. If you don't want to make the custom toolbar, you can access the same commands using the Draw menu on the Drawing toolbar.

Dock these toolbars in convenient locations.

VBATrain Home | Samples TOC | Previous | Next