Edit Components

You can edit standard modules, class modules, and forms in the VBA IDE. Standard and class modules are edited in a Code window. Forms are edited in the UserForm window using a special toolbox.

You can open as many Code windows as you have modules, so you can easily view the code in different forms or modules, and copy and paste between them.

To edit a component in your project

  1. In the Project window of the VBA IDE, select the component you want to edit.
  2. Select the View Code button in the Project window to open a Code window.
  3. Select the View Object button in the Project window to open a UserForm window and associated toolbox.

To access the code associated with a form