How to define complex numbers in Excel and perform mathematical operations such as addition, subtraction, multiplication and division.

When creating Userforms in Excel VBA, you can use the Controls collection to easily loop through controls and set a property of each control to a specific value.

Below we will look at a program in Excel VBA that converts text to proper case.

Below we will look at a program in Excel VBA that colors the maximum value of a dynamic range.

Below we will look at a program in Excel VBA that counts the number of words in a selected range.

Below we will look at a program in Excel VBA that creates a footer before printing a workbook.

Below we will look at a program in Excel VBA that creates a pattern.

Below we will look at a program in Excel VBA which creates a Userform that converts any amount from one currency into another.

Below we will look at a program in Excel VBA which creates a User Defined Function.

The DateDiff function in Excel VBA can be used to get the number of days between two dates.

This example teaches you how to debug code in Excel VBA.

To execute a sub in Excel VBA after a specific time, use onTime, Now and the TimeValue function.

Below we will look at a program in Excel VBA that deletes blank cells.

Below we will look at a program in Excel VBA which creates a Userform that contains dependent combo boxes.

Although not used very often on this site, you might find yourself in a situation where you want to use the Do Until Loop in Excel VBA.