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

Open the file you want to edit the VBA.

Microsoft Visual Basic for Applications dialog box opens

Microsoft Visual Basic for Applications dialog box opens

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

Articles related to Alt & F11

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments