Shortcut to open VBA in Excel (Alt + F11)
Here is how to open VBA using shortcut keys: the Microsoft Visual Basic for Applications dialog box allows you to create macros that are even more complex than macro records and register them in Excel. Normally, when you open the Microsoft Visual Basic for Applications dialog box, you need to open the development tab, but this shortcut key allows you to open the editor immediately, making coding even smoother.
Shortcut to open VBA
Windows
Alt + F11
Mac
option + F11
Open the VBA with the shortcut key
Learn how to open the Microsoft Visual Basic for Applications dialog box using shortcut keys.
Total Time: 1 minute
Open the file

Open the file you want to edit the VBA.
Microsoft Visual Basic for Applications dialog box opens

Press Alt + F11 to open the Microsoft Visual Basic for Applications dialog box.