Open VBA Editor in Excel (Shortcut)

VB Editor is the place where you can add VBA codes and create macros that can be used to automate tasks in Excel.

We also need to open Excel’s VB editor whenever we need to add or modify VBA codes. 

The option to open VB Editor in the Developer tab in Excel

By default,  the Developer tab is hidden, and to get it in the ribbon, you need to enable it.

But, if you know how to use the shortcut to open the VBA Editor in Excel, you do not need to add the Developer tab to your Excel file.

Shortcut to Open VBA Editor in Excel

Below is the keyboard shortcut to open the VBA Editor in Excel.

ALT + F11

If you are using a Mac version, the keyboard shortcut to open the VBA Editor in Excel is:

Opt + F11

How to Use the Keyboard Shortcut

Below are the steps to use the above keyboard shortcut to open the VB Editor in Excel:

  1. Open/Activate the Excel file in which you want to open the VB Editor.
  2. Press and hold the ALT key.
  3. Press the F11 key.

Then, Excel will open a separate window for the VBA Editor.

Important Things to Know

Below are some important things to know when using a shortcut to open the VBA Editor in Excel.

  1. The above keyboard shortcut may not work if the function keys are locked. Then, you have to press the “Fn” key as well. Therefore, you have to use ALT + Fn + F11 as the keyboard shortcut to open the VBA Editor in Excel.
  2. You can use the ALT + F11 to toggle between the VBA Editor window and the Excel workbook.

Other Excel shortcuts you may also like:

Other articles you may also like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment