graphic2
graphic1

Hello, Visual Basic!

The Macros are written in Microsoft's Visual Basic for Applications (VBA) programming language. Here are the steps to Edit a Macro in VBA.

 

6. Try it: Edit the Macro

Go to Developer ->Code->Macros.

The Macro Manager should be open.
Select a Macro: UpdateProducts.

Click on Edit.

 

What Do You See? The VBA Editor will open in a new window. On the left side should be a VBAProject. Each sheet and the tab name is listed in the Microsoft Excel Objects. On the right side is the code.

 

Keep going...

 

Memo to Self: This is the same VBA editor that you can use in Microsoft Access, Outlook, PowerPoint and Word to program Macros.

Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.4 Customize Options and Views for Worksheets and Workbooks: Edit Simple Macros

Developer ->Code->Macros-> Edit