Posted by
Andy Brown
on 25 January 2014
You can use Visual Basic within Excel, PowerPoint or Word to draw shapes, format them and even assign macros to run - this long blog gives lots of ideas of how to proceed!
Posted by
Andy Brown
on 06 March 2012
It's not for the faint-hearted, but there is a way to capture application events (such as someone trying to create a new workbook) in Excel, using something called an event sink. This blog explains how you might go about creating an event sink.
Posted by
Andy Brown
on 05 March 2012
If you've learnt how to create your own objects using classes in Excel VBA, the next step is to learn how to group them together into collections. This on-line tutorial will show you how.
Posted by
Andy Brown
on 07 July 2023
If you've written a killer function, you'll want to be able to share it between workbooks. The best way to do this is using an add-in.
Posted by
Andy Brown
on 05 March 2012
Those who want to add spice to their VBA programming can learn how to create classes, or class modules, and become object-orientated programmers. It's difficult, but fun - and this multi-part blog will guide you along the way.
Posted by
Andy Brown
on 28 February 2012
The two previous parts of this mini-blog have shown how to draw forms and how to write code to handle form events. This final part shows how to add some of the more exotic controls to user forms, like combo boxes, list boxes, multipage controls, spinners and option buttons.
Posted by
Andy Brown
on 27 February 2012
The previous part of this three-part series showed how to draw user forms; this part shows how to write macros to get them to work (the final part shows how to use some of the more advanced controls, such as combo boxes and MultiPages).
Posted by
Andy Brown
on 27 February 2012
Learn how to create your own custom dialog boxes in VBA, using UserForms. This is the first part of a three-part series (the other parts are on Writing Code for UserForms and Creating Advanced Controls).
Posted by
Andy Brown
on 24 February 2012
On-line training in writing functions using VBA, for use either within other VBA programs or within Excel itself.
Posted by
Andy Brown
on 24 February 2012
Excel and other MS Office applications make extensive use of enumerations - and you should too!
Posted by
Andy Brown
on 24 February 2012
You can use arrays (multiple variables) in VBA to speed up code - and they are also invaluable for processing CSV files and the like.
Posted by
Andy Brown
on 20 February 2012
In certain cases in VBA (displaying the contents of folders, listing hierarchical data) writing a program which calls itself is by far the easiest way to go - this blog gives worked examples of 3 such recursive programs.
Posted by
Andy Brown
on 09 February 2012
To become an efficient programmer, you need to stop writing one long subroutine and start writing lots of small ones instead - and to do this, you're going to need to know everything there is to know about passing arguments.
Posted by
Andy Brown
on 06 February 2012
Learn how to write VBA macros to add, edit and delete data in Access, SQL Server and other databases, using something called ADO.
Posted by
Andy Brown
on 23 January 2012
By referencing the unintuitively named Microsoft Scripting Runtime object library you can write VBA code to access files and folders on your hard disk. This blog explains how, and gives a couple of worked examples.
Posted by
Andy Brown
on 13 January 2012
The easiest way to work with text files in VBA is using TextStream objects - this blog explains how they work.
Posted by
Andy Brown
on 13 January 2012
In order to work efficiently with files and folders you first need to create a FileSystemObject. This blog explains how to do this!
Posted by
Andy Brown
on 13 January 2012
To make it easier for users of your VBA systems to choose files, you can show FileDialogs on screen. This blog explains what these are, and how to customise them.
Posted by
Andy Brown
on 03 January 2012
Did you know that you can create and manage references from within VBA code? This article gives you ideas on how to do just that.
Posted by
Andy Brown
on 09 December 2011
Although it's usually easiest to create references to other applications using the Tools/References menu as described in an earlier blog, you can use the method shown in this blog instead.