Visual Basic For Application (VBA)

Excel VBA (Visual Basic for Applications) is the name of the programming language of Excel.

Create a Macro

With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro.

MsgBox

The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program.

Workbook and Worksheet Object

Learn more about the Workbook and Worksheet object in Excel VBA.

Range Object

The Range object, which is the representation of a cell (or cells) on your worksheet, is the most important object of Excel VBA.

Variables

This chapter teaches you how to declare, initialize and display a variable in Excel VBA.

If Then Statement

Use the If Then statement in Excel VBA to execute code lines if a specific condition is met.

Loop

Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.

Macro Errors

This chapter teaches you how to deal with macro errors in Excel.

String Manipulation

In this chapter, you'll find the most important functions to manipulate strings in Excel VBA.

Date and Time

Learn how to work with dates and times in Excel VBA

Events

Events are actions performed by users which trigger Excel VBA to execute code.

Array

An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the index number.

Function and Sub

In Excel VBA, a function can return a value while a sub cannot.

Application Object

The mother of all objects is Excel itself. We call it the Application object. The application object gives access to a lot of Excel related options.

ActiveX Controls

Learn how to create ActiveX controls such as command buttons, text boxes, list boxes etc.

Userform

This chapter teaches you how to create an Excel VBA Userform.