You can also open VBA in Excel using Alt + F11 keyboard shortcut.

If the Developer tab is not present, go to File -> Options -> customize ribbon and tick Developer. Read on to see How to Open and Start Using the MS Excel VBA EditorĬlick the visual basic button on the developer tab. Having access to the VBA editor lets you write your own VBA code or review recorded macros. This quick tip guide shows you how to open the Excel Visual Basic Editor (aka Excel VBA Editor) and get started with VBA programming in Excel. It can be used to automate many repetitive tasks along with more complex applications. The following VBA code snippet can be set as a Button event to open the VBA Project Window: Sub OpenVBE_Click()Ī VBA is a powerful tool which enables the automation of tasks in Excel. May sound weird but it is actually a pretty neat trick. Tip 1: Open the VBE (Visual Basic Editor) with VBA THe VBE Code Window allows you to edit your VBA code – by selecting a VBA Module, Classes or Form in the VBE Project Window (see above). The VBE Project Windows allows you to manage your VBA Project objects such as VBA Modules, Classes and Forms. This will open the Visual Basic editor as shown below: The Visual Basic Editor (VBE) The VBE Project Window You should now see a new tab in your Excel ribbon called Developer as shown below: Click the Visual Basic button on the Developer ribbon Next select the Developer tab to add it to the Excel ribbon as shown below:Ĭlick Ok. Did you know… you can use the ALT+ F11 keyboard shortcut to open the Visual Basic Editor (VBE) window? Add the Developer tab to your Excel ribbon

Vb project excel