When you record a macro, Excel translates your actions into VBA code under the hood. So in addition to creating macros by recording them, you can also write them manually in VBA code.

Learn how to use macros in Excel 365 to ... Macros operate by recording a series of actions you perform in Excel and translating them into VBA code. ... where you can view, run, or edit your macros.

Understanding the Macro Recorder. Excel’s Macro Recorder is a built-in feature designed to automate repetitive tasks by converting your actions into VBA (Visual Basic for Applications) code.

How to add the VBA procedures in Excel Choosing either item in the dropdown does nothing right now. We need to add the event procedure that runs when you select one of the items in the dropdown.