VBA in Excel Archives - Page 2 of 3

How to Use VBA OnKey Event in Excel (with Suitable Examples)

Feb 9, 2023

While we work in Excel, Excel constantly monitors what we do. Sometimes you may want to perform something when you press a particular keystroke for ...

How to Use VBA OnKey Event in Excel (with Suitable Examples)

Excel VBA Worksheet Events and Their Uses

Feb 13, 2023

We will highlight the worksheet-related events, how to add them in Excel VBA, and their uses in this article. Worksheet events in Excel are actions ...

Excel VBA Worksheet Events and Their Uses

Excel VBA: Workbook Level Events and Their Uses

Feb 11, 2023

In this article, I am going to introduce you to Excel Workbook-level events. This introduction will help you to use them in the future efficiently. ...

Excel VBA: Workbook Level Events and Their Uses

Excel VBA Events (A Complete Guideline)

Nov 30, 2022

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

How to Use Excel Combo Box (A Complete Guideline)

Sep 18, 2023

Do you want to learn how to use Excel Combo box? Combo box in Excel provides predefined options, assuring precise inputs and allowing efficient data ...

How to Use Excel Combo Box (A Complete Guideline)

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

Sep 18, 2023

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

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

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

Feb 28, 2023

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 Change Tabbing Order in Excel (4 Easy Methods)

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

Sep 18, 2023

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

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

How to Create Excel VBA UserForm (with Detailed Steps)

Sep 18, 2023

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 Excel VBA UserForm (with Detailed Steps)

How to Create a UserForm: an Overview

Feb 12, 2023

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 Excel VBA Userform (2 Suitable Examples)

Feb 20, 2023

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 Use Excel VBA Userform (2 Suitable Examples)

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

Apr 24, 2023

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

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

Difference Between Subroutine and Function in Excel VBA

Sep 18, 2023

There are lots of similarities between a custom Function/User-Defined Function procedure and the Sub-procedure/Subroutine in Excel. However, Function ...

Difference Between Subroutine and Function in Excel VBA

25 VBA Macro Example for Enhanced Productivity

May 17, 2023

When it comes to boosting output or gaining time at work, macros are your best friend. Using the VBA coding language, we can automate anything from ...

25 VBA Macro Example for Enhanced Productivity

List of 10 Mostly Used Excel VBA Objects (Attributes & Examples)

Feb 9, 2023

This article is part of my series: Excel VBA & Macros – A Step by Step Complete Guide. We will discuss a list of only 10 mostly used Excel VBA ...