Type in a new name for your macro, then click “Create”Īfter clicking “Create” the VB Editor will appear, showing the newly created macro.

Select the Developer tab and click Macros (or press ALT+F8).

To create a new macro using the Macros list: From this list you can edit an existing macro, or create a new one. The Macros List shows you all the macros in your workbook. Making Your First Macro Using the Macros List

Modules (macros are stored in these items)Īlthough all these item types can include VBA code, the best practice is to code macros in Modules.

There are several types of items that can appear in the Project Explorer: If you don’t see this window, press F5 to make it appear or select Project Explorer from the View menu.ĭouble-clicking an item in the Project Explorer will show the code for that item. The Project Explorer is a window inside the VB Editor that shows you all the items that can have VBA code in them.

Typically, you’ll open this editor with the ALT+F11 keyboard shortcut in Excel, but you can also access it from Excel’s Developer tab if you have it enabled.

This is a special text editor and debugger that’s built-in to all office apps, including Excel. You can access all the VBA code in a workbook using the Visual Basic Editor. All macros are stored as VBA code, whether they’re hand-coded or created with the macro recorder. VBA, or Visual Basic for Applications, is the language that macros are written in. Getting Started VBA and the Visual Basic Editor You’ll learn where Macros are stored, write a basic macro, and learn the basics of programming in VBA using variables, logic, and loops. This article aims to help you begin coding macros from scratch in VBA. It can also be hard to use for longer macros – you may find yourself storyboarding your actions beforehand just to avoid making costly mistakes. As covered in another article, the macro recorder often records unnecessary code and can’t record things like logic or interactions with other programs. Excel Macros Disabled? – How to Enable MacrosĮxcel’s macro recorder has a lot of power, but it has its limitations.

Writing a code