Chapter 14. Creating Simple Custom Dialog Boxes

In this chapter, you'll start looking at Visual Basic for Applications' tools 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 elaborate 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 do the following:

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

Get Mastering VBA for Microsoft® Office 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.