# Top VBA Functions

HomeVBA TutorialTop VBA Functions

Once you get started with VBA, the next important thing is to learn how to use in-built VBA functions while writing a VBA code.

So here I have listed the Top 100 VBA Functions (Category Wise) in detail with examples and sample codes, and these functions are listed under specific categories (10) to make you understand the purpose of each function easily.

Below is the list of categories of the major VBA functions, all the functions are further listed under these categories:

Table of Content

## VBA TEXT (String) Functions

VBA TEXT functions help you to manipulate text value(s) from a cell, range of cells, or from an entire worksheet or workbook. In simple words, these functions are specifically built for changing text values.

Below we have a list of 18 TEXT functions that you can learn to use:

## VBA DATE Functions

VBA DATE functions are specifically built to deal with dates from data. With these functions, you can extract part of a date, add or subtract days from a date, the difference between two dates.

Below we have a list of 12 DATE functions which you can learn to use:

## VBA TIME Functions

VBA Time functions help you to work with time values and manipulate them if you want. You can extract a part from time value, add hours, minutes, and hours to a time, calculate the difference between two-time values.

Below we have a list of 8 TIME functions which you can learn to use:

## VBA MATHS Functions

VBA MATHS functions are designed to perform specific mathematical calculations. In simple words, these functions perform calculations that are complex to perform otherwise.

Below we have a list of 13 MATHS functions which you can learn to use:

## VBA Logical Functions

VBA LOGICAL functions help you to test conditions and return a value if that condition and other if that value is FALSE.

Below we have 1 LOGICAL function which you can learn to use and you can also use VBA IF in your codes:

## VBA Information Functions

VBA INFORMATION functions help you to get specific information from the Excel application environment. You can check if a value is a date if there’s an error or if you have an object.

Below we have a list of 8 INFORMATION functions which you can learn to use:

## VBA Financial Functions

VBA Financial functions help you to perform financial calculations with the values you input. You can calculate depreciation, future values or rate of interest for investment and loan.

Below we have a list of 12 FINANCIAL functions which you can learn to use:

## VBA ARRAY Functions

VBA ARRAYS functions help you deal with arrays. You can filter values from an array, join and split a string.

Below we have a list of 6 ARRAY functions which you can learn to use:

## VBA Data Type Conversion Functions

VBA Data Type Conv. functions help you convert a value from one data type to another data type, like, converting a number which is stored as text into a long data type.

Below we have a list of 20 Data Type Conv. functions which you can learn to use:

## VBA Error Handling Functions

VBA Error Handling functions help you to get information about the error occurs in a VBA code. Below we have 1 Error Handling function which you can learn to use and you can also use error handling techniques in your codes: