How to Create a Custom Visual Basic Editor Toolbar

A good workman always knows his tools and in this tutorial I show you how to create your own custom toolbars in the Visual Basic Editor. It’s a free beginner level tutorial and I use Microsoft Excel 2016. The video uses MS Excel 2016 but the same steps are used for MS Excel 2010, Excel…

Dynamic Named Ranges in Excel

A great way of making your macros and code more robust is to use dynamic named ranges. These automatically adjust and resize as the underlying data changes and I use them whenever I can. In this beginner level tutorial we start with a completely blank spreadsheet. We build a number of lists within a worksheet…

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: Using the Developer Ribbon Tab; Using a shortcut key combination (Alt + F11); If we have…