Macros & Excel VBA Archives - Page 46 of 70

Excel VBA: Filter Date before Today (With Quick Steps)

Nov 11, 2025

In Microsoft Excel, working with dates is a pretty common thing. And filtering those dates is also a day-to-day task for a lot of Excel users. Now, ...

Excel VBA: Filter Date before Today (With Quick Steps)

Excel VBA: Count Rows in Named Range (4 Methods)

Nov 11, 2025

We can count rows in a named range by using workbook functions or conditional formatting but if we work with a large amount of data then using VBA ...

Excel VBA: Count Rows in Named Range (4 Methods)

How to Use Named Range for Data Validation List with VBA in Excel

Nov 11, 2025

If you are looking for the easiest ways to use named range for data validation list in Excel VBA, then you will find this article useful. Named ...

How to Use Named Range for Data Validation List with VBA in Excel

How to Use Excel VBA to Create Data a Validation List from Array

Jul 5, 2024

The salespersons' dataset has their working region and selling products. We will create a data validation list for the Region and Product ...

How to Use Excel VBA to Create Data a Validation List from Array

Excel VBA: Cell Reference in Another Sheet – 4 Methods

Aug 3, 2024

This is the sample data set. Method 1- Reference Cells in Another Sheet with Excel VBA Copy the data in D5 in ‘Sheet2’ to ‘Sheet1’ Step 1: ...

Excel VBA: Cell Reference in Another Sheet – 4 Methods

How to use Excel VBA with an Advanced Filter – 6 Examples

Aug 15, 2024

This is the sample dataset. Example 1 - Use Excel VBA to Filter Data in the Current Location Set the criteria in B16:E17. Step 1: ...

How to use Excel VBA with an Advanced Filter – 6 Examples

VBA Conditional Formatting Based on Another Cell Value in Excel

Nov 11, 2025

When we are dealing with a large amount of data in Excel, sometimes we want to format the dataset in certain conditions for better readability. ...

VBA Conditional Formatting Based on Another Cell Value in Excel

Excel VBA: Count Characters in Cell: 5 Methods

Jun 6, 2024

Method 1 - Use of VBA Len Function to Count Characters in a Cell in Excel The LEN function in VBA Excel returns the number of characters in a text ...

Excel VBA: Count Characters in Cell: 5 Methods

How to Count Filtered Rows in Excel with VBA (Step-by-Step Guide)

May 18, 2024

Suppose you have the following dataset. Step 1 - Apply a Filter to the Dataset Select any cell of your dataset. Go to the Data ...

How to Count Filtered Rows in Excel with VBA (Step-by-Step Guide)

VBA to Check If CheckBox Is Checked in Excel: 3 Ways

Jul 5, 2024

Method 1 - Embed VBA Macro to Check If a CheckBox Is Checked with a Numeric Value in Excel Add a checkbox to examine whether the checkbox is checked ...

VBA to Check If CheckBox Is Checked in Excel: 3 Ways

Excel VBA: Combine Date and Time (3 Methods)

Nov 11, 2025

While making a time log of activities in Excel, you may want to combine date and time. In most cases, you may have dates in one column and time in ...

Excel VBA: Combine Date and Time (3 Methods)

How to Use VBA to Delete Rows with Specific Data in Excel (9 Examples)

Jul 15, 2024

Dataset Overview In this tutorial, we’ll explore various examples of deleting rows using Excel VBA. Let’s start by considering the following ...

How to Use VBA to Delete Rows with Specific Data in Excel (9 Examples)

Excel VBA: Advanced Filter with Multiple Criteria in a Range

May 26, 2024

VBA Advanced Filter Syntax: AdvancedFilter: refers to a range object. You can set the range where you want to apply the Filter. Action: ...

Excel VBA: Advanced Filter with Multiple Criteria in a Range

Excel VBA: Form Control Checkbox Value – 3 Examples

Aug 9, 2024

The dataset showcases a course registration form with 6 different courses. Using a Code in the Visual Basic Editor Go to the Developer ...

Excel VBA: Form Control Checkbox Value – 3 Examples

Using Excel VBA to Count Blank Cells in a Range – 3 Methods

Aug 8, 2024

This dataset contains blank cells. Method 1 - Embed a VBA to Count Blank Cells in a Range with the COUNTIF Function Steps: ...