Macros & Excel VBA

MsgBox Function in Excel VBA

The MsgBox function The VBA MsgBox function is an easy way to display information and to take simple input (like Yes, No, Cancel) from the users. ...

InputBox Function in Excel VBA

The InputBox function The InputBox function is useful for obtaining a single input from the user. A simplified version of the function’s syntax ...

Creating a UserForm that will change cases to Upper, Lower or Proper

This article is part of my series: VBA & Macros in Excel – A Step by Step Complete Guide and Make UserForms in VBA Excel with Total 6 Tutorials. ...

How to create an Excel VBA UserForm

This article is part of my series: VBA & Macros in Excel – A Step by Step Complete Guide and Make UserForms in VBA Excel with Total 6 Tutorials. ...

How to Create a UserForm: an Overview

In many cases, it is adequate to use InputBox and MsgBox functions. Using InputBox function, a user can provide only a single input to Excel. So, to ...

MsgBox & InputBox in VBA Excel : UserForm Alternatives

If you practice regularly, developing UserForms isn’t difficult. But using built-in functions of Excel to perform the same thing is easier. VBA ...

Why UserForms are Necessary in Excel

This article is part of my series: VBA & Macros in Excel – A Step by Step Complete Guide and Make UserForms in VBA Excel with Total 6 Tutorials. ...

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 ...

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 a range. It is ...

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 ...

How to Use Excel VBA User Defined Function in Formula

Excel VBA provides two procedures. One is functions also known as the user-defined functions another one is subroutines. In this tutorial, I am going ...

What is an Argument in Excel with Example

Excel has many functions for different operations.  Inside the parenthesis of the functions, we put some inputs for the desired operation that we ...

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 to create custom VBA functions and use them ...

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 a macro Sub procedure. Macro Sub ...

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 ...

ExcelDemy
Logo