Edit Components

Import Existing Components

Edit Your Projects with the VBA IDE

Use the Code Window

 

Getting Started with VBA > Edit Your Projects with the VBA IDE > 

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

• To access the code associated with a control, double-click on any control in the Form window. The code associated with that control will open in a Code window.