The shortcut key to open the VBA Editor in Excel is “Alt + F11.”
In this quick guide, let me show how to open the VBA Editor in Excel using a keyboard shortcut or from the Developer tab. That is unless you know the exact keyboard shortcut or enabled the Developer tab in Excel, it is very hard to find and open the VBA Editor in Excel.
Since scripting is considered an advanced feature, the VBA Editor is hidden by default. That's how to show the Developer tab in Excel.To create or add custom scripts in Excel, you have to use the built-in Visual Basic Editor. On the next start of Excel, the tab will remain hidden until you select its checkbox again. If at some point you decide that you do not need the Developer tab on your Excel ribbon, simply right-click on any tab on the ribbon, pick Customize the Ribbon, and clear the Developer box. Once the tab is positioned properly, click OK to save the changes.Each click moves the tab one position to the right or left on the ribbon.
This article shows how to quickly activate it. You want to access one of advanced Excel features but are stuck at the very first step: where's the Developer tab they are all talking about? The good news is that the Developer tab is available in every version of Excel 2007 to 2019, though it is not enabled by default. This short tutorial will teach you how to get Developer tab in Excel 2010, Excel 2013, Excel 2016, and Excel 2019.