VBA

How To Use VBA Complex Calculations In Excel

Oct 24, 2020

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

How To Use VBA Controls Collection In Excel

Oct 24, 2020

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.

How To Use VBA Convert to Proper Case In Excel

Oct 24, 2020

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

How To Use VBA Dynamic Range In Excel

Oct 23, 2020

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

How To Use VBA Count Words In Excel

Oct 23, 2020

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

How To Use VBA Create a Footer Before Printing

Oct 23, 2020

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

How To Use VBA Create a Pattern In Excel

Oct 23, 2020

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

How To Use VBA Currency Converter In Excel

Oct 23, 2020

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

How To Use VBA Custom Average Function In Excel

Oct 23, 2020

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

How To Use VBA DateDiff Function In Excel

Oct 23, 2020

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