Macros & Excel VBA

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

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

Excel VBA Calculate Cell

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

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

[Fixed!] Excel VBA: Global Variable Loses Value

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

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

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

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

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

Excel VBA Range Address – 5 Examples

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

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)

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

Compare Two Excel Sheets and Highlight Differences Macro

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

Excel Evaluate String as Formula (2 Easy Ways)

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 VBA Manual Calculation on Workbook Open

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

Excel VBA to Calculate Active Sheet (6 Practical Applications)

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

How to Handle Excel VBA On Error GoTo 0 

While working on a dataset, sometimes you need to sum up numbers or do other operations. This is quite easy while you are working on a small dataset, ...

How to Use Excel VBA Select Case and Operator

,In this article, we will discuss VBA codes with Select Case and related Operator(s). The Select Case statement is one of the control structures ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo