Business Solutions VBA for the 2007 Microsoft Office System

12Creating Custom VBA Dialog Boxes

IN THIS CHAPTER

Adding a Form to Your Project

Changing the Form’s Design-Time Properties

Working with Controls

Handling Form Events

Types of Form Controls

Using a Form in a Procedure

VBA procedures are only as useful as they are convenient. There isn’t much point in creating a procedure that saves you (or your users) a few keystrokes if you (or they) have to expend a lot of time and energy hunting down a routine. Shortcut keys are true time-savers, but some applications (such as Excel) have only a limited supply to dole out (and our brains can memorize only so many Ctrl+key combinations).

Instead, you need to give some thought to the type of user interface you want to create for your VBA application. ...