ExcelDemy.com Blog

How to insert an Excel VBA custom function 1

How to insert an Excel VBA custom function

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. We can use Excel’s Insert Function dialog box to locate a custom function and insert it...

An Excel VBA function with a range argument 0

An Excel VBA function with a range argument

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. Well, the last type of argument is range. It is demonstrated here. Lets make some assumption....

An Excel VBA function with two arguments 0

An Excel VBA function with two arguments

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. In this example, I am going to write a VBA function that will calculate the area...

An Excel VBA function with one argument 1

An Excel VBA function with one argument

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. Before entering into details, at first I introduce you with the method Speak(). This method has...

An Excel VBA function with no argument 0

An Excel VBA function with no argument

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. Though most VBA functions use arguments, but that’s not a requirement. Excel has some predefined functions...

LARGE function in Excel 0

LARGE function in Excel

LARGE Function: Overview The LARGE function in Microsoft Excel returns the nth largest value from a data range. LARGE function: Syntax LARGE (array, nth_position) LARGE function: Parameters or Arguments The syntax has the following...

AND Function in MS Excel 0

AND Function in MS Excel

AND Function: Overview The Microsoft Excel AND function returns TRUE if all logic are TRUE. It returns FALSE if any of the logic is FALSE. AND function: Syntax AND (logic1,[logic2], …) AND function: Parameters...

A detailed analysis of Excel VBA Function Procedure Arguments 1

A detailed analysis of Excel VBA Function Procedure Arguments

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. We knew how create custom VBA functions and use them in the worksheet. This article focuses...

How to Execute a Function Procedure 0

How to Execute a Function Procedure

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. We know how to create macro Subprocedure. Macro Subprocedure can be executed in many ways. But,...

How to Create Custom VBA functions and Use them in the Worksheet 0

How to Create Custom VBA functions and Use them in the Worksheet

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. We already know that there are two types of VBA macros from this article: Two types...

How to Write a Function Procedure in Visual Basic Editor 1

How to Write a Function Procedure in Visual Basic Editor

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. There are lots of similarities between a custom Function procedure and a Subprocedure. However, Function procedures...

For-Next loops in Excel 1

For-Next loops in Excel

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. For-Next loops We use a For-Next loop to execute one or more statements for more than...

A macro example created using VBA 0

A macro example created using VBA

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. The following is a VBA macro that you can’t create by recording. It uses programming concepts...

Objects and collections, Properties, Methods, and Variables in Excel VBA 0

Objects and collections, Properties, Methods, and Variables in Excel VBA

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. Objects and collections VBA is an object-oriented programming language. As name shows, object oriented language works...