Creating a digital certificate for your VBA projects is easy, but deleting them is somewhat less obvious. This blog shows you how to use the certificate manager to remove certificates that you no longer need.

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.

This blog is part of our Excel VBA training series of blogs.

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.

You can find more articles on this subject in our Excel Visual Basic tutorial blog.

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.

This is one small part of our free online Excel VBA tutorial.

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.

This blog is part of our Excel VBA tutorial.

Visual Basic for Applications (VBA) is what's called an object-orientated programming language. This blog explains what this means!

This series of blogs is part of our Excel VBA online tutorial.

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!

This blog is part of our Excel macros online training series.

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.

This blog is part of our Excel macros online training series.

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.

Commenting code is an art form! This series of blogs explains why, how and when to comment in VBA.

This blog is part of our Excel macros online training series.