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