Excel Hack

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

Open the file you want to edit the VBA.

Microsoft Visual Basic for Applications dialog box opens

VBA editor opens

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

Articles related to Alt & F11