Macros & Excel VBA Archives - Page 2 of 70

How to Make and Use a ColorIndex Value Chart in Excel

Jun 17, 2024

Below is an image showing each color palette in ColorIndex and their RGB value. Predefined Names of an Excel VBA ColorIndex There are 8 ...

How to Make and Use a ColorIndex Value Chart in Excel

VBA Evaluate Array Formula

Nov 11, 2025

In the article, titled VBA Evaluate Array Formula, we'll look at three effective ways to use VBA's Evaluate function to efficiently manipulate data ...

How to Use Excel VBA to Run a Macro When the Cell Value Changes – 3 Examples

Aug 4, 2024

Overview: Example 1. Running a Macro When a Specific Cell Value Changes The dataset showcases students and their marks. A ...

How to Use Excel VBA to Run a Macro When the Cell Value Changes – 3 Examples

Excel VBA Calculate Cell

Nov 11, 2025

In this article, we will learn how to use Excel VBA to calculate cell. We will calculate cell, workbook, worksheet, range, and formula using Excel ...

Excel VBA: How to Refresh All Data Connections – 4 Examples

Aug 3, 2024

This is an overview. Create Data Connections between Excel Files The original dataset is the Dataset sheet in the Source Sheet workbook . ...

Excel VBA: How to Refresh All Data Connections – 4 Examples

[Fixed!] Excel VBA: Global Variable Loses Value

Nov 11, 2025

In this article, we are going to show you why the VBA global variable loses value in Excel. Normally, the global variables lose their value after ...

[Fixed!] Excel VBA: Global Variable Loses Value

How to Use Excel VBA to Add a Comment to a Cell – 3 Examples

Aug 9, 2024

This is an overview. If you are new to Microsoft Visual Basic Application, read How to Write VBA Code in Excel. Example 1 - ...

How to Use Excel VBA to Add a Comment to a Cell – 3 Examples

VBA to Call Sub From Another Workbook in Excel (With Examples)

Jul 7, 2024

In this article, we will demonstrate how to utilize VBA to call a subroutine (sub) from another workbook, both opened and closed. We will also ...

VBA to Call Sub From Another Workbook in Excel (With Examples)

Excel VBA Range Address – 5 Examples

Aug 9, 2024

This is an overview. Download Practice Workbook Download the workbook and practice. Range Address.xlsm Syntax of the Excel ...

How to use the Excel VBA Watch Window

Aug 11, 2024

Below, you can see how the watch window monitors the variable value in Excel VBA. How to Add a Watch Window Open the VBA code editor ...

How to Get Cell Value as String Using Excel VBA (4 Easy Ways)

Jul 5, 2024

Here's an overview of the VBA code needed to get cell values. How to Get Cell Value as String with Excel VBA: 4 Approaches Method 1 - Get ...

How to Get Cell Value as String Using Excel VBA (4 Easy Ways)

Compare Two Excel Sheets and Highlight Differences Macro

Nov 11, 2025

In this article, we will learn how to compare two Excel sheets and highlight differences using a macro. So, let's start. Sometimes we are working on ...

Compare Two Excel Sheets and Highlight Differences Macro

Excel Evaluate String as Formula (2 Easy Ways)

Nov 11, 2025

In this article, we will explore the idea to evaluate a string as a formula in Microsoft Excel. The necessity of this feature is discussed, ...

Excel Evaluate String as Formula (2 Easy Ways)

Excel VBA Manual Calculation on Workbook Open

Nov 11, 2025

This article provides a comprehensive guide on implementing VBA manual calculation on workbook open, taking into account diverse user requirements ...

Excel VBA Manual Calculation on Workbook Open

Excel VBA to Calculate Active Sheet (6 Practical Applications)

Aug 2, 2024

Sometimes, when working with large datasets, Excel won't compute all the formulas in the cells. One solution to this problem is to use VBA to ...