This is where you write and edit your code and procedures, and also where macros get recorded by you. Refer Image 1 to view Visual Basic Editor and its components.

Using the SendKeys Method for keystrokes wherein combining the CTRL key is done by preceding the keycode with ^ (caret), we can open the Project Explorer if it was previously closed: 'To display the Project Explorer window, you can use the shortcut keys CTRL +R in VBE.

'launch VBE and go to the 'VBACode' procedure in a Standard Module - the Goto Method selects the vba procedure: 'use this code to open VBE and Project Explorer 'using the ActiveCodePane Property, show the active or last active CodePane object (note - a code window can contain multiple code panes: 'use the MainWindow Property which represents the main window of the Visual Basic Editor - open the code window in VBE, but not the Project Explorer if it was closed previously:Ī = TrueĪ = False To launch VBE using macro code - refer below code(s) which will enable you to open / close the VBE code window with a command button on your worksheet: Right click the active worksheet tab at the bottom, then click on View Code to display VBE. Select a Macro Name and click on Edit.Ĭlick Tools -> Macro -> Visual Basic Editor or To edit a Macro in VBE: On the Developer tab, in the Code group, click Macros, which opens the Macro dialog box. Press Alt+F11 keys combination to switch back and forth between workbook environment and VBE.

Right Click the active worksheet tab at the bottom, then click on View Code to display VBE. On the Developer tab, in the Controls group, click View Code to display VBE. On the Developer tab, in the Code group, click Visual Basic to display VBE. The Visual Basic Editor (VBE) in Excel is an environment used to write, edit and debug VBA code, and is contained in the Microsoft Excel workbook. Visual Basic Editor in Excel (VBE) - the VBA Code Editor

Excel visual basic editor