Latest Blog Posts - Page 85 of 589

How to Use Nested Select Case with VBA in Excel (3 Examples)

Nov 11, 2025

The Select Case statement is one of the most commonly used statements in Excel VBA. It allows Excel users to perform different actions based on a ...

How to Use Nested Select Case with VBA in Excel (3 Examples)

Excel VBA to Sort Worksheet (3 Examples)

Nov 11, 2025

If you use Excel frequently, you are likely aware of how difficult it can be to handle. After you have more than a couple of worksheets, you need to ...

Excel VBA to Sort Worksheet (3 Examples)

Excel VBA Offset Within Loop (4 Examples)

Nov 11, 2025

In this article, we will talk about the usage of Excel VBA Offset Within Loop. It is a very effective function in its own right. However, when ...

Excel VBA Offset Within Loop (4 Examples)

Excel VBA Select Case Like: 7 Examples

Jul 8, 2024

Syntax of the Select Case Statement The basic syntax for the Select Case statement in VBA is as follows: Select Case expression Case value1 ...

Excel VBA to Find Cell Address Based on Value (3 Examples)

Jul 7, 2024

The sample dataset contains the sales data of a certain showroom. Example 1 - Finding Only First Cell Address Based on Value By default, ...

Excel VBA to Find Cell Address Based on Value (3 Examples)

Using the Excel VBA ActiveCell Offset Property – 13 Examples

Aug 12, 2024

How to Launch the VBA Editor in Excel The Developer tab contains the VBA applications. Enable the Developer tab. Note: By default, the Developer ...

Using the Excel VBA ActiveCell Offset Property – 13 Examples

VBA InputBox for Integer Value Only in Excel

Nov 11, 2025

The InputBox method in Visual Basic for Applications (VBA) is a helpful way to collect user input from within an application. This article will ...

VBA InputBox for Integer Value Only in Excel

Excel VBA 2 Dimensional Array Initialization

Aug 1, 2024

Overview of a 2-Dimensional Array (2D Array) Definition A 2-dimensional array, also known as a 2D array, is an array that has data spread out ...

Excel VBA 2 Dimensional Array Initialization

Export Folder and Subfolder List to Excel (with Quick Steps)

Jul 4, 2024

The Power Query tool can be used to export .xlsx and .txt file inside a folder and subfolder list to Excel. Step 1 - Choose a Folder from ...

Export Folder and Subfolder List to Excel (with Quick Steps)

[Fixed!!] VBA Sort Not Working in Excel

Nov 11, 2025

In VBA, sorting data is a common task, but it can be frustrating when the sort function doesn't work as expected. This article will discuss the ...

How to Use an Array of Strings in VBA (4 Examples)

Jul 10, 2024

Introduction to VBA Array Arrays are powerful tools for managing data, and they allow you to group related values under a single variable name. Here ...

How to Use an Array of Strings in VBA (4 Examples)

Excel VBA Select Case True

Nov 11, 2025

VBA Select Case True is a very useful statement while working with multiple conditions. This statement is more concise and presents the ...

How to Use UBound on Multidimensional Array with VBA in Excel

Nov 11, 2025

Today, we are going to discuss how to use the UBound function on a multidimensional array with VBA. This function is a very commonly used Array ...

How to Use UBound on Multidimensional Array with VBA in Excel

Excel VBA Sort Array Alphabetically

Nov 11, 2025

Sorting is an essential operation that involves arranging a set of data in ascending or descending order based on their numeric values or leading ...

Create InputBox with Multiple Inputs With VBA UserForm in Excel: 8 Step-by-Step Methods

May 22, 2024

Method 1 - Insert User Form to Create InputBox with Multiple Inputs in Excel The Visual Basic window will open. We’ll insert an UserForm from the ...