VBA & Macro Problems

Run Excel VBA When Any Cell in a Column Changes

John WilsonJohn Wilson Nov 18, 2026 870 views

Question details

Trigger a message or another VBA action when any cell in a specified Excel column changes.

Run Excel VBA When Any Cell in a Column Changes
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants a worksheet event to respond to edits anywhere in column A.
Observed behavior
When a cell or range in column A changes, the VBA procedure should identify the changed range and run the desired action.
Before you start

Open the workbook in desktop Excel and identify the worksheet and column you want to monitor. Save the workbook as an Excel Macro-Enabled Workbook (.xlsm) and enable macros only if you trust the file.

Solution 1Recommended

Use Worksheet_Change to Monitor Column A

Add a worksheet event that displays the changed portion of column A whenever a user edits or pastes cells there.

1
Open the worksheet code

Right-click the tab of the worksheet you want to monitor and select View Code.

2
Add the event procedure

Paste the following code into the worksheet's code window: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Me.Columns("A")) Is Nothing Then MsgBox "The changed range is " & Intersect(Target, Me.Columns("A")).Address(False, False) End If End Sub

3
Save and test

Save the workbook as an .xlsm file, return to the worksheet, and edit or paste a value in column A. A message should show the changed address or range.

4
Adapt the action

In the worksheet code window, replace the MsgBox line with your own VBA action. To monitor another column, change "A" in both references to the desired column letter.

Use Worksheet_Change to Monitor Column A
Existing events and formula changes: A worksheet can have only one Worksheet_Change procedure, so add the column check to the existing procedure if one is already present. This event does not fire when a formula result changes because of recalculation.
Free Microsoft Office alternative

Edit Spreadsheet Columns with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Excel format compatibility for easier migration. Use it to work with column data, but verify macro requirements separately; it does not fix Excel's VBA event behavior.

Edit and organize data in spreadsheet columnsOpen and edit common Microsoft Excel formats, including .xlsx and .xlsNavigate a familiar spreadsheet interfaceUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where should I paste the Worksheet_Change code?

Right-click the relevant worksheet tab, select View Code, and paste the procedure into that worksheet's code window, not a standard module.

Will the event run if I paste into several cells at once?

Yes. Worksheet_Change receives the changed range as Target, and Intersect identifies the part of that range in column A.

Why doesn't the event run when a formula result changes?

Worksheet_Change does not fire for changes caused by recalculation. Consider the Worksheet_Calculate event if you need to respond to recalculation.

Why is my macro not running after I reopen the workbook?

Check that the file is saved as .xlsm and that macros are enabled for the trusted workbook. Also check that events have not been disabled; in the VBA editor's Immediate window, you can enter Application.EnableEvents = True.

Can I run this VBA event in Excel for the web?

No. Excel for the web does not run VBA macros. Open the workbook in desktop Excel to use the Worksheet_Change event.