Macros & Excel VBA Archives - Page 18 of 70

How to Evaluate String as Code with Excel VBA (2 Examples)

Nov 11, 2025

Are you looking for ways to evaluate string as code with Excel VBA? Visual Basic for Applications (VBA) is a versatile programming language widely ...

How to Evaluate String as Code with Excel VBA (2 Examples)

How to Create a Timer with Milliseconds in Excel VBA

Jul 29, 2024

Step 1 - Creating a Data Set with Timers Open a workbook and put your desired alert times, just like the screenshot below. Read More: ...

How to Create a Timer with Milliseconds in Excel VBA

How to Input Dialog Box in Excel VBA (2 Easy Examples)

Nov 11, 2025

In this short tutorial, I will show you how to create an input dialog box through VBA in Excel. Fortunately, Excel has a built-in function named ...

How to Input Dialog Box in Excel VBA (2 Easy Examples)

Excel VBA ComboBoxes – 4 Examples

Aug 12, 2024

How to Add a ComboBox in Excel This is the sample dataset. Steps: Go to the Developer tab >> Insert >> Combo Box (ActiveX ...

How to Perform Drawing of Objects with VBA in Excel (2 Examples)

Jul 30, 2024

Example 1 - Drawing Simple Shapes with VBA Code We will design a rectangle, a cell-sized rectangle, and a cube. Steps: Open your worksheet. ...

How to Perform Drawing of Objects with VBA in Excel (2 Examples)

VBA Union Method to Join Range in Excel (3 Examples)

Nov 11, 2025

The VBA Union method helps to put several ranges into one single range. You can also find and sort a wide range of data into one single range based ...

VBA Union Method to Join Range in Excel (3 Examples)

How to Use VBA Code for Making a Digital Clock in Excel: 2 Steps

Jul 5, 2024

Method 1 - Employ VBA Code in Module Press Alt + F11 to open your Microsoft Visual Basic. Press Insert > Module to open a blank module. ...

How to Use VBA Code for Making a Digital Clock in Excel: 2 Steps

How to Draw in Excel Using VBA – 5 Examples

Aug 13, 2024

Example 1 - Using the VBA AddShape Method to Draw in Excel Steps: Go to the Developer tab >> click Visual Basic. In the ...

How to Draw in Excel Using VBA – 5 Examples

How to Add Tooltip to UDF in Excel

Nov 11, 2025

Today we will talk about ways to add Tooltip to UDF or User Defined Function in Excel. Tooltips are small descriptions of functions when we enter the ...

How to Convert TextBox Value to Cell with VBA in Excel

Jul 30, 2024

In this article, we will explain in detailed steps how to convert a TextBox value into a cell with VBA in Excel. We'll build a UserForm to input ...

How to Convert TextBox Value to Cell with VBA in Excel

How to Reset ComboBox to Default Value Using VBA

Nov 11, 2025

In this article, we will show how to reset ComboBox to the default value using the VBA code. ComboBoxes are a great tool to store a list and then ...

How to Reset ComboBox to Default Value Using VBA

How to Use VBA Dictionary in Excel: 6 Practical Methods

Jul 3, 2024

Method 1 - Create a VBA Dictionary Steps: Open the Microsoft Visual Basic window by pressing Alt+F11 . Click on the Tools tab and go to, ...

How to Use VBA Dictionary in Excel: 6 Practical Methods

How to Create a Countdown Timer in Excel VBA (with Easy Steps)

Jul 16, 2024

What Is a Countdown Timer? A countdown timer is a type of digital clock that starts counting down from a specific date or number. It's commonly used ...

How to Create a Countdown Timer in Excel VBA (with Easy Steps)

Clear Excel Memory Cache Using VBA (3 Easy Ways)

Jun 2, 2024

This article describes three straightforward Excel VBA methods for clearing cache memory, a process which improves application speed. We'll use ...

Clear Excel Memory Cache Using VBA (3 Easy Ways)

How to Add Item to ComboBox with VBA in Excel

Jul 26, 2024

What Is a ComboBox in Excel? A ComboBox allows users to create or choose from a list of options. It is a type of a drop-down list based on a ...