VBA Functions Archives

Using the Excel VBA Function to Return Multiple Values – 6 Methods

Aug 10, 2024

The image below showcases how three results can be obtained, using the ByRef argument in the Excel VBA function. Method 1 - Returning ...

Using the Excel VBA Function to Return Multiple Values – 6 Methods

How to Return a Value in VBA Function (Both Array and Non-Array Values)

Nov 11, 2025

In this article, I’ll show you how you can return a value from a User-Defined Function in VBA in Excel. I’ll show you how to return an array value, a ...

How to Return a Value in VBA Function (Both Array and Non-Array Values)

VBA Sub Vs Function in Excel (5 Differences)

Nov 11, 2025

In this article, I'll compare Sub Vs Function in VBA in Excel. Sub and Function are two important and widely used features that we use while working ...

VBA Sub Vs Function in Excel (5 Differences)

How to Create Custom Function in Excel VBA

Jul 23, 2024

Here's an overview of a custom function that was made via VBA code. As you can see, the function has lowercase letters, unlike traditional Excel ...

How to Create Custom Function in Excel VBA

How to Create a VBA Function with Arguments in Excel – 4 Examples

Aug 14, 2024

Example 1 - Creating a VBA Function with a Single Argument Create a function to convert Kg to Grams: Steps: Enter the following code in the ...

How to Create a VBA Function with Arguments in Excel – 4 Examples

How to Use VBA User Defined Function (4 Suitable Examples)

Jul 13, 2024

What Is a VBA User Defined Function? A user defined function is a custom function made by users according to their needs. It is a collection of ...

How to Use VBA User Defined Function (4 Suitable Examples)

How to Execute VBA Function Procedure in Excel (2 Easy Ways)

Jul 29, 2024

This article is part of a series: Excel VBA & Macros – A Step by Step Complete Guide. Method 1 - Calling Custom Functions from Procedure to ...

How to Execute VBA Function Procedure in Excel (2 Easy Ways)

Difference Between Subroutine and Function in Excel VBA

Jul 19, 2024

There are lots of similarities between a custom Function/User-Defined Function procedure and the Sub-procedure/Subroutine in Excel. However, Function ...