Posted by
Andy Brown
on 05 December 2011
Even if you're writing Visual Basic macros within Excel, there's nothing to stop you inserting text into Word documents, manipulating PowerPoint slides or sending Outlook emails. This blog explains how to reference other applications, and write macros in Excel to link to other Microsoft Office software
Posted by
Andy Brown
on 29 November 2011
What happens when your macros go wrong? That depends what error-handling you have in place. Learn how to use ON ERROR and other commands to trap errors in a structured way.
Posted by
Andy Brown
on 25 November 2011
This series of blogs is intended to provide online training in how to debug in Visual Basic for Applications, including using breakpoints and the immediate window.
Posted by
Andy Brown
on 22 November 2011
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 15 November 2011
There are 4 types of loop in Visual Basic for Applications - this blog shows how and when to use each type of VBA loop structure.
Posted by
Andy Brown
on 07 July 2023
This part of the Excel VBA training series of blogs shows how to use IF / ELSE / END IF within VBA, and also how to use the alternative SELECT / CASE syntax within macros.
Posted by
Andy Brown
on 07 July 2023
Visual Basic for Applications (VBA) is what's called an object-orientated programming language. This blog explains what this means!
Posted by
Andy Brown
on 03 October 2011
The InputBox function in Visual Basic for Applications allows you to get - as the name suggests - input from the user. This blog shows how to use it!
Posted by
Andy Brown
on 28 September 2011
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
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
As well as running introductory and advanced VBA training courses in the UK for small groups, we've also published this online training course teaching how to code macros using Visual Basic for Applications (VBA) within Excel. The tutorial covers everything from basic recording through to creating classes - something for everyone!
Posted by
Andy Brown
on 16 August 2011
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
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 30 June 2011
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
Andy Brown
on 28 April 2011
Commenting code is an art form! This series of blogs explains why, how and when to comment in VBA.