How to Open the Visual Basic Editor in Excel

In Microsoft Excel, when we want to do some coding in Visual Basic for Applications (VBA) we first need to open up the Visual Basic Editor (VBE). There are three key methods I tend to use to do this:

  1. Using the Developer Ribbon Tab;
  2. Using a shortcut key combination (Alt + F11);
  3. If we have a macro assigned to a button then using this to go directly to our procedure (by right clicking and using the context menu);

In this beginner level tutorial we walk through how to use each of these techniques to open up the VBE and allow you to start coding in VBA.  The video below uses MS Excel 2010 but the same steps are used for MS Excel 2013 and Excel 2016.

If you enjoyed this short tutorial then please add a comment, start a discussion, “Like”, “Favourite” or “Share” the tutorial and subscribe to my channel.

Subscribe to The Office Ninja

Subscribe to the Office Ninja

Leave a Reply

Your email address will not be published. Required fields are marked *