Writing Your First Excel VBA Function

In this tutorial we will learn about Excel VBA function 1) What is Visual Basic in Excel? 2) How to use VBA in Excel? 3) How to create User def...

How to Use Your Excel Add-In Functions in VBA

If you have built an Add-In to contain your Excel custom functions you might have discovered that, although the functions work fine in an Excel worksh...

Sum the digits numbers in a cell using custom VBA function in Microsoft Excel

In this article, we will create a custom function to calculate the sum of digits in a cell. Sample data for this example consists of sales data. ...

Worksheet functions in VBA macros using VBA in Microsoft Excel

In VBA code, if you have to refer to certain worksheet functions like Sum, Vlookup, etc, you can use them directly by using the Application object. ...

Using a User Defined Function (UDF) from another workbook using VBA in Microsoft Excel

In this article, we will see how to use a User Defined Function (UDF) defined in another workbook. For this example, we have created a UDF “Reverse...

Generate list of unique random numbers using VBA in Microsoft Excel

In this article, we will create a custom function to generate a list of unique and random numbers between the specified ranges. In this example, we c...

Return error values from user defined functions using VBA in Microsoft Excel

Return error values from user defined functions With the example function below you can get user defined functions to return error values just like ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube