Macros & Excel VBA

How to Use Activex Control in Excel (With Easy Steps)

This tutorial will demonstrate how to use ActiveX control in excel. ActiveX control is a more flexible design than any of the Form controls. Using ...

Key Differences in Excel: Form Control Vs. ActiveX Control

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

How to Change Tabbing Order in Excel (4 Easy Methods)

In this tutorial, I am going to share with you 4 easy methods to change tabbing order in excel user forms. These methods will make your daily ...

How to Use VBA Asc Function (5 Practical Examples)

In this article, we will discuss Excel VBA Asc Function. It is a convenient tool. I hope you will find the article interesting and can increase your ...

How to Use VBA Input Function in Excel (2 Examples)

This article highlights how to use the VBA Input function in excel. We will use some relevant examples to illustrate the uses of this function. You ...

Excel VBA to Change Case of Selected Text (6 Useful Examples)

When working with Excel, sometimes You might need to prepare your dataset in the same format of text casing. In this regard, you need to know how to ...

How to Create Excel VBA UserForm (with Detailed Steps)

If you are searching for some special tricks to create VBA UserForm in Excel then you have landed in the right place. There are some quick steps to ...

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

How to Use MsgBox and InputBox in VBA Excel

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

How to Use Excel VBA Userform (2 Suitable Examples)

It is impossible to use Excel for a long time without being exposed to dialog boxes. Excel uses dialog boxes to get information from the users, make ...

How to Create VBA Custom Function in Excel (2 Easy Methods)

This tutorial will demonstrate how to create an excel VBA custom function. While working in Excel VBA, we often need to use custom functions. Users ...

How to Use VBA Average Function in Excel (4 Practical Examples)

Average estimation is a very common factor in our everyday life. In the business section, it is an important factor to summarize the production or ...

How to Make VBA Function with Arguments in Excel

Excel has a lot of built-in functions, but we can make our own functions according to our recruitment or applications. In this article, we’ll ...

How to Use VBA User Defined Function (4 Suitable Examples)

While working in Excel VBA, we often need to use user defined function. Users can use these functions as regular functions of Excel. When the inbuilt ...

What Are Excel Function Arguments (A Detailed Discussion)

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

ExcelDemy
Logo