VBA Functions

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

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

How to Create Custom Function in Excel VBA

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 a VBA Function with Arguments in Excel – 4 Examples

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 Use VBA User Defined Function (4 Suitable Examples)

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 Execute VBA Function Procedure in Excel (2 Easy Ways)

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

Difference Between Subroutine and Function in Excel VBA

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo