This page has 0 threads | Add post

Visual Basic for Applications tutorials

We've published 45 guides on how to use VBA, divided into the following categories:

Recording and running macros (3)

A good place to start when learning VBA for Excel is to learn how to record macros, and then have a look at the code created for you.

Show these tutorials

Writing VBA code (3)

Creating basic modules and procedures in VBA, including commenting code

Show these tutorials

Selecting cells and ranges (2)

You can't do much in Excel VBA without knowing how to move around a worksheet!

Show these tutorials

Messages, input boxes and variables (3)

How to display input and message boxes, as well as how to create and use variables.

Show these tutorials

Object-oriented programming (1)

Understand how VBA is written, using objects, collections, properties and methods:.

Show this tutorial

Testing conditions (1)

How to use IF / ELSE / END IF within VBA, and also how to use the alternative SELECT / CASE syntax within macros.

Show this tutorial

Loops (4)

Learn the four main types of loop built into VBA.

Show these tutorials

Events (5)

In Excel VBA you can attach code to events which happen for a workbook or worksheet (such as running code whenever you open a particular file).

Show these tutorials

Debugging (1)

Stepping through code, setting breakpoints, using the call stack and other options for debugging macros.

Show this tutorial

Error-handling (1)

Using the Err object to display errors, and trapping for errors using ON ERROR and RESUME.

Show this tutorial

Referencing applications (3)

Linking to other applications such as Word or PowerPoint from within Excel,.

Show these tutorials

Working with files and folders (4)

You can use FileDialogs to choose files to open or save, TextStream objects to read and write files and create a FileSystemObject to copy, move or delete files:.

Show these tutorials

Working with databases (1)

How to use ActiveX Data Objects (ADO) to link to SQL Server or Access databases from within Excel (or do it the other way round, and link from Access to Excel, say).

Show this tutorial