Run Excel VBA When Any Cell in a Column Changes
Question details
Trigger a message or another VBA action when any cell in a specified Excel 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.
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.
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.
Right-click the tab of the worksheet you want to monitor and select View Code.
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
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.
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.

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.

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.




