Mastering VBA for Microsoft Office 2007, 2nd Edition

Chapter 14

Creating Simple Custom Dialog Boxes

In this chapter, you’ll start looking at the capabilities that Visual Basic for Applications provides for creating custom dialog boxes that interact with the user. Dialog boxes are one of the most powerful and complex features of VBA. This chapter covers the more straightforward dialog box elements and how to manipulate them. The next chapter shows you how to create more complex dialog boxes, such as those that contain a number of tabbed pages and those that update themselves when the user clicks a control.

In this chapter you will learn to:

• Understand what you can do with a custom dialog box
• Create a custom dialog box
• Add controls to a dialog box
• Link dialog boxes to procedures
• Retrieve the user’s ...