Assign keyboard shortcut to Vba macro code in Excel. Once it is mapped, pressing the same combination of the keys will invoke the mapped macro & execute the code in it. The shortcut for the Mac version is Opt + F11 or Fn + Opt + F11. Using the Developer Tab. To open the Visual Basic Editor from the ribbon. Now if you have to run this code, you need to manually execute the macro. Adding VBA Code in Module. While recording a macro automatically creates a module and inserts the code in it, there are some.

This Tutorial Covers: • • • • • • • • • • • • • • • • • • • • • What is Visual Basic Editor in Excel? Visual Basic Editor is a separate application that is a part of Excel and opens whenever you open an Excel workbook. By default, it’s hidden and to access it, you need to activate it.

VB Editor is the place where you keep the VB code. There are multiple ways you get the code in the VB Editor: • When you, it automatically creates a new module in the VB Editor and inserts the code in that module. • You can manually type VB code in the VB editor. • You can copy a code from some other workbook or from the internet and paste it in the VB Editor. Opening the VB Editor There are various ways to open the Visual Basic Editor in Excel: • Using a Keyboard Shortcut (easiest and fastest) • Using the Developer Tab.

• Using the Worksheet Tabs. Let’s go through each of these quickly.

Keyboard Shortcut to Open the Visual Basic Editor The easiest way to open the Visual Basic editor is to use the keyboard shortcut – ALT + F11 (hold the ALT key and press the F11 key). As soon as you do this, it will open a separate window for the Visual Basic editor. This shortcut works as a toggle, so when you use it again, it will take you back to the Excel application (without closing the VB Editor). The shortcut for the Mac version is Opt + F11 or Fn + Opt + F11 Using the Developer Tab To open the Visual Basic Editor from the ribbon: • Click the Developer tab (if you don’t see a developer tab, on how to get it). • In the Code group, click on Visual Basic. Using the Worksheet Tab This is a less used method to open the Vb Editor. Go to any of the worksheet tabs, right-click, and select ‘View Code’.

This method wouldn’t just open the VB Editor, it will also take you to the code window for that worksheet object. This is useful when you want to write code that works only for a specific worksheet. This is usually the case with. Anatomy of the Visual Basic Editor in Excel When you open the VB Editor for the first time, it may look a bit overwhelming. There are different options and sections that may seem completely new at first. Also, it still has an old Excel 97 days look.

While Excel has improved tremendously in design and usability over the years, the VB Editor has not seen any change in the way it looks. In this section, I will take you through the different parts of the Visual Basic Editor application. Note: When I started using VBA years ago, I was quite overwhelmed with all these new options and windows. But as you get used to working with VBA, you would get comfortable with most of these.