ExcelDemy.com Blog

Why We Use Form Controls on a Worksheet? 0

Why We Use Form Controls on a Worksheet?

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. In our previous articles, you have been introduced with Excel UserForms. In this chapter, I am...

ASC Function(VBA) in Excel 0

ASC Function(VBA) in Excel

ASC(VBA) Function: Overview The Microsoft Excel ASC(VBA) function returns the ASCII value of a character or the first character in a string passed as arguments. ASC(VBA) function: Syntax   Asc( string ) ASC(VBA) function:...

MsgBox Function in Excel VBA 0

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. MsgBox function: Syntax A simplified version of the...

InputBox Function in Excel VBA 0

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 follows: InputBox function: Syntax InputBox ( prompt, [title], [default] ) InputBox...

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

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. In this tutorial, I am going...

How to create an Excel VBA UserForm 2

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. So far we have learned the...

How to Create a UserForm: an Overview 2

How to Create a UserForm: an Overview

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. In many cases, it is adequate...

MsgBox & InputBox in VBA Excel : UserForm Alternatives 0

MsgBox & InputBox in VBA Excel : UserForm Alternatives

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. If you practice regularly, developing UserForms...

Why UserForms are Necessary in Excel 1

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. It is impossible to use Excel...

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