Paul The Programmer

So you now know what VBA is, and roughly what it might be able to do. Great. But where do we actually create the list, or code.

Well, the samples I’ll show you on my tutorials are all in Microsoft Excel. Firstly because it’s the first office application on my menu bar (and lazy is my second name), but more importantly screen grab works well so I can show you what I’m doing.

So open up excel…..Pause for effect….Now open up the VBA editor.

Gasp – shock horror, where is it? Easy, it can be found under Tools > Macro > Visual Basic Editor – see the picture below. Go on click it, I know you want to.

Now you have broken your computer, unless you can see the editor environment that looks like this

In which case congratulations; you now know how to get into the VBA editor. Well done.