Using Visual Basic editor in Excel for the object code window is pretty simple. Hence, the trigger or the action of the object here is the opening of the workbook, which leads to the code getting applied to the workbook object as a reaction. For instance, if you want a macro to unhide all the worksheets in a workbook, then as soon as the workbook (the object here) opens, the code would be applied to the object of this Workbook. When adding a macro to an object code window, the reaction generated somewhat depends on the action of the object. The basic difference between object code window and module code window lies in the application of macros. They are applied to all selected cells and changes happen on their own. These actions are automated when you create a macro in Excel and run it. What are Macros? Macro is an action or set of actions that enable you to perform tasks with automation. So, first, let’s get our basics in place – VBA lets you create Macros and write scripts in Excel. There are two places where you can add code when using Visual Basic Editor in Excel With this method, you can write worksheet-specific codes.Ĭlick here to know about How To Spell Check In Excel. Once you do that, you will be taken to the code window for the worksheet with the VBA editor also running. Step 2: Then, right-click and select view code. The steps for this method are as follows: The worksheet tab is the less frequently used method when it comes to opening the Visual Basic editor in Excel. Step 2: In the Code, click on Visual Basic. In order to open the Visual Basic editor from the ribbon:

This method to open Visual Basic in Excel is also called the ribbon method. Step 2: If you press the same shortcut keys again, then you will be taken back to the Excel application, with the Visual Basic editor still open in the background.įor the MAC system, the shortcut keys to open the Visual Basic editor in Excel are OPT+F11 or Fn+OPT+F11. Once you press this key, it will immediately open up another window for the Visual Basic editor. Step 1: In the Windows system, you can use the key combination ALT+F11. The keyboard shortcut is the easiest way to open the Visual Basic editor in Excel. How To Open Visual Basic Editor? Keyboard Shortcut

Visual basic for excel 2010