Microsoft® Office Excel 2003 Programming Inside Out

Chapter 19. Creating User Forms

Creating a UserForm

UserForm Controls

User forms give Microsoft Excel programmers the opportunity to provide a different way for users to interact with their applications. In this chapter, you’ll learn how to create a form and populate it with the standard controls supplied by Microsoft Visual Basic for Applications (VBA). Then you’ll learn how to display and close forms from your own routines. Finally, you’ll learn how to interact with the form from your VBA application.

Creating a UserForm

Visual Basic for Applications includes a special object known as a UserForm. A UserForm object provides a visible surface on which you can place graphical controls, such as buttons, images, and text areas.

Adding a UserForm ...