Edit Your Macro in Visual Basic Editor
To edit your macro, you have to go to the Visual Basic Editor (VBE). It is also the
place for you to create and manage macros. This page will orientate you to the key
elements you need to know about visual basic editor before your create or edit your macro.
Having the right view will help you find out quickly where you have stored your codes,
access the code directly, and also to find out the property of each object. An object could
mean a worksheet, the entire workbook, a userform or a folder called module
where the macro codes are stored
- To open the VBE, go to Menu -> Tools -> Macro -> Visual Basic Editor
- I recommend that you set up the visual basic editor to have the following views:
- Project Explorer - contains the workbooks (including addins and personal macro workbook)
that are opened in Microsoft Excel. In the diagram, we have an addin called PDFMaker.xla,
a workbook called "Book1" and our personal workbook called "Personal.xls".
- The properties window - will show the properties of the item
within workbook or addin. If we select a worksheet found within a workbook
(e.g. Book1) by click on the left mouse button over the "+" sign, we will
see a list worksheets (e.g. Sheet1, Sheet2, etc). Selecting one of the
worksheets will display the properties for that worksheet.
- View the macros in details
- Move your mouse cursor to the project explorer and over the "+" sign on the left
of project called "VBAProject(Personal.xls)".
- Click on left mouse button. You should see 2 folders, namely, Microsoft
Excel Objects and Modules. Click on the Modules folder and you will see
another folder called Macro1.
- Double Click on Macro1 and the window on the right would pop up with the
code to our recorded macro. This is the place where you will edit your macro
- Where else can we store the macro?
- You can also stored codes in the Microsoft® Excel Objects folder and
the userform folder.
- Excel Objects folder usually store codes that are triggered by an event in the workbook or
worksheet. Examples of events are opening the workbook, activating the worksheets,
selecting the cells in a worksheet, double click with the left mouse button, etc.
- Userform folder is the location where we design a dialog box which we could interact
with the users. The code stored in this folder is normally related to the items in the
Do you have
any question regarding edit your macro?
Ask Jason Khoo.