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.

To view your macro, click the Macros icon/button or press Alt+ F8. 5. The Macros dialog appears, displaying all the macros saved to the “All Open Workbooks” area.

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.

2. Use specific VBA code with directional keys. Always use directional keys to navigate through spreadsheets. In Excel, these keys include Home, End, Page Up, Page Down, and the four arrow keys ...