If you have a colleague who trusts you, you could always betray this trust by sending them a workbook which misbehaves: it won't close and you can't leave it!
Posted by Andy Brown on 22 November 2011 | 2 comments
Want to do something when a user opens a workbook, or stop them clicking on a particular cell? You need to learn how to attach code to Excel workbook or worksheet events!
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 | 4 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 | 4 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.
Posted by Andrew Gould on 08 June 2011 | 7 comments
Adding basic data labels to a chart can be done without using any programming code. This blog, however, shows you how to fine-tune Excel chart labels using VBA (Visual Basic for Applications) macros.