Chapter 13. Creating Custom VBA Dialog Boxes

In This Chapter

Adding a user form (custom dialog box) to your project

• Changing the look and behavior of the form

• Inserting, selecting, and manipulating form controls

• Understanding and working with the various form controls, from command buttons to check boxes

Displaying and closing forms and getting the form results

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 ...

Get Absolute Beginner's Guide to VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.