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:
- Open/Activate the Excel file in which you want to open the VB Editor.
- Press and hold the ALT key.
- 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.
- 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.
- 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: