Posted by
Andy Brown
on 26 September 2016
A short blog explaining how you can get Excel to read out values in cells every time that you recalculate a worksheet.
Posted by
Andy Brown
on 17 December 2015
This short blog shows that there is a third way to refer to a range, other than using the RANGE or CELLS keywords.
Posted by
Andy Brown
on 17 December 2015
There are two ways you can display an input box using Excel macros: the standard VBA InputBox function, or the much better (but lesser known, at least by this blog's author) Application.InputBox function.
Posted by
Andrew Gould
on 26 November 2015
You can give your VBA code a performance boost by simply turning off screen updating while your code runs. This blog explains how to achieve this and how to create a basic timer to test the results.
Posted by
Andy Brown
on 15 September 2014
I've already pinched (with permission!) the ideas of Fergus Cairns to explain ways to run automatic searches on popular websites like Google; this blog gives an update on the same topic.
Posted by
Andy Brown
on 13 January 2014
You can use VBA to extract data from web pages, either as whole tables or by parsing the underlying HTML elements. This blog shows you how to code both methods (the technique is often called "web-scraping").
Posted by
Andy Brown
on 25 November 2013
You can get at all sorts of system information within Visual Basic for Applications by using environment variables - this blog shows you how to get at your user's name, computer name and much more besides.
Posted by
Andy Brown
on 07 November 2013
A short blog explaining how to use Visual Basic for Applications to loop over enumerations.
Posted by
Andy Brown
on 14 May 2013
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 04 April 2013
If your chart has more than a thousand data labels, this blog explains why you may experience problems.
Posted by
Andrew Gould
on 30 May 2012
This follow-up article to a previous blog describes how to label the data points in multiple series in Excel using VBA.
Posted by
Andrew Gould
on 01 July 2011
If you've heard people in your office talking about macros or VBA but don't understand what they mean, this blog series will make everything clear. It's an introduction to the most basic skills you'll need to start creating your own programs in any of the Microsoft Office applications.
Posted by
Andrew Gould
on 08 June 2011
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.
Posted by
Michael Allsop
on 01 June 2011
Do your macros keep falling over due to users renaming their worksheets in Excel? Read this article to find out if sheet codenames could be the solution you need.