Search Contextures Sites

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: Copy the code that you want to use Select the workbook in which you want to store the code Hold the Alt key, and press the F11 key, to open the Visual Basic Editor Choose Insert | Module Where the cursor is flashing, choose Edit | Paste To run the code: Choose Tools | Macro | Macros 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: Copy the code that you want to use Select the worksheet in which you the code to run Right click on the sheet tab and choose View Code, to open the Visual Basic Editor. 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: Copy the code that you want to use Select the workbook in which you want to store the code Hold the Alt key, and press the F11 key, to open the Visual Basic Editor In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects Right-click on the ThisWorkbook object, and choose View Code Where the cursor is flashing, choose Edit | Paste

Home     Excel Tips     Excel Files      Blog    Contact
Privacy Policy		The Excel Store	Debra Dalgleish