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.