Excel -- VBA -- Adding Code to a Workbook

Copy Code to a Regular Module  
Copy Code to a Worksheet Module
 
Copy Code to a Workbook Module 

  


Copy Code to a Regular Module

You may find code in a newsgroup message, or on a web site, and decide to add it to one of your workbooks. Most code can be added by doing the following:

  1. Copy the code that you want to use
  2. Select the workbook in which you want to store the code
  3. Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
  4. Choose Insert | Module
  5. Where the cursor is flashing, choose Edit | Paste

To run the code:

  1. Choose Tools | Macro | Macros
  2. Select a macro in the list, and click the Run button

Watch the Video

View the steps described above, in a short video clip.

 

 


Copy Code to a Worksheet Module

Some code is Event code, and will run automatically when something specific occurs in the workbook. For example, if you type in a cell, and press the Enter key, the worksheet has been changed. This could trigger the Worksheet_Change event.

Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:

  1. Copy the code that you want to use
  2. Select the worksheet in which you the code to run
  3. Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
  4. Where the cursor is flashing, choose Edit | Paste

 


Copy Code to a Workbook Module

If code is Workbook Event code, it should be added to the workbook code module:

  1. Copy the code that you want to use
  2. Select the workbook in which you want to store the code
  3. Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
  4. In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
  5. Right-click on the ThisWorkbook object, and choose View Code
  6. Where the cursor is flashing, choose Edit | Paste

 

 

       Home     Excel Tips     Excel Files      Blog    Contact

 

RSS Feed

 

 

 

The Excel Store

Last updated: July 18, 2008 11:59 PM