05-Dec-2012 : Accessing the Visual Basic Environment (Excel)

Save your workbook before you proceed any further. If you’re using Excel 2007, you’ll need to make sure it’s saved as a macro-enabled workbook (*.xlsm). Keep this copy as a backup: VBA code can be extremely destructive and there’s no Undo facility to fall back on!

Select Developer > Visual Basic from the Excel menu bar to open the Visual Basic Environment (VBE) or press Alt-F11.

The VBE comprises four main types of window:-

Project Explorer: a tree view of […]