Posted by Andy Brown on 12 August 2013 | no comments
Deep within its bowels Excel contains a feature allowing it to read out the contents of cells (you can also get your VBA macros to talk to users). This blog goes to those deep places hidden within Excel!
Posted by Andy Brown on 28 September 2011 | 2 comments
The MsgBox command in Visual Basic for Applications allows you to display basic messages, but you can also make it prettier, and even use it to ask questions or display multiple-line messages! Read on to find out more about this versatile VBA command.
Posted by Andy Brown on 05 September 2011 | 6 comments
This blog explains the nuts and bolts of Excel VBA variables, including how to declare them, how to set their scope and all sorts of other tips and tricks. The blog also covers constants in Excel macros.
Posted by Andy Brown on 16 August 2011 | 5 comments
Use this free online training in Excel Visual Basic for Applications (VBA) to learn how to program macros within Excel. The tutorial covers everything from basic recording through to creating classes - something for everyone!
Posted by Andy Brown on 16 August 2011 | no comments
This blog shows the various techniques within Excel Visual Basic for moving around and selecting cells relative to the active cell or selection. The blog includes a discussion of the Offset, End, Resize, Range, EntireRow, EntireColumn and CurrentRegion methods.
Posted by Andy Brown on 11 August 2011 | no comments
This blog gives the various possible ways to select cells, ranges, columns and rows using Visual Basic for Applications in Excel. Useful for the VBA newbie, but even gurus might find one or two commands they'd missed!
Posted by Andy Brown on 01 July 2011 | no comments
This short blog shows how to assign short-cut keys to macros in Excel 2010, Excel 2007 and Excel 2003. So if you've written a whizzy macro in VBA and want to be able to run it with a single keystroke combination, read on!
If you're not sure what the Excel Visual Basic for Applications language is, or how it can help you, this blog attempts to explain! Learn what VBA is, and how you can record macros and then replay them again and again to automate work in Excel.