Latest Posts

How to Enter Event Handler VBA Code

In my last article, I have introduced you to Excel events and their types. In this article, I am going to narrate to you how to enter Event Handler ...

What are Excel Events and Their Types

So far in various articles, I have discussed about Events and Event handlers. To give you a fresh start, let's have a look at the Events and Events ...

Excel ActiveX Controls Properties (Checkbox, Combo box, List box, …)

In this article, I am going to give an overview of available ActiveX controls that you can use in your worksheet. After reading this article, you ...

How to Use ActiveX Controls in Excel (Step by Step)

In this article, you will learn how to use ActiveX controls in Excel, step by step. You'll be relieved to hear that adding ActiveX controls in a ...

Excel Form Control vs. ActiveX Control (7 Differences)

In our previous articles, you have been introduced to Excel UserForms. In this chapter, I am going to discuss Excel Form Control Vs Activex Control. ...

Adding accelerator keys & Controlling tab order in Excel UserForms

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

Excel VBA ASC() Function – Get ASCII Value of Character

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

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

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

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

ExcelDemy
Logo