A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

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 […]