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.

#Tutorial#How To#VBA#Loop

How To Use VBA Controls Collection In Excel

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.

#Tutorial#How To#VBA#Userform

How To Use VBA Convert to Proper Case In Excel

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

#Tutorial#How To#VBA#String Manipulation

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.

#Tutorial#How To#VBA#Range Object

How To Use VBA Count Words In Excel

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

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

#Tutorial#How To#VBA#Events

How To Use VBA Create a Pattern In Excel

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

How To Use VBA Currency Converter In Excel

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

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

#Tutorial#How To#VBA#Function

How To Use VBA DateDiff Function In Excel

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

#Tutorial#How To#VBA#Date and Time