MS-Excel / General Formatting

Adding a Form to Your Project

Forms are separate objects that you add to your VBA projects. To do this, open the Visual Basic Editor and either choose Insert, UserForm or drop down the Insert toolbar button (the second from the left) and click UserForm. VBA performs the following tasks in response to this command:

  • It adds a Forms branch to the project tree in the Project Explorer.
  • It creates a new UserForm object and adds it to the Forms branch.
  • It displays the form in the work area.
  • It displays the Toolbox.
[Contents] [Next]

In this tutorial:

  1. Creating Custom VBA Dialog Boxes
  2. Adding a Form to Your Project
  3. Changing the Form's Design-Time Properties
  4. Working with Controls
  5. Handling Form Events
  6. Types of Form Controls
  7. Using a Form in a Procedure