VBA do action if changes in particular range

[cozzagiorgi]

Hi

How can I monitor a particular range and do an action if something in this range changes?

I know how to monitor an entire worksheet, but not how to watch only a particular range or even cell.

 

[JoeMo]

Use a worksheet_change event macro. What range do you want to monitor and what do you want to happen if a user changes any cell in that range?

 

[My Aswer Is This]

Here is a example.
Any time you make a change in values in column A column B will now have the current time and date entered:

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified 6/27/18 6:05 PM EDT
If Not Intersect(Target, Range("A:A")) Is Nothing Then
If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
Target.Offset(, 1).Value = Now()
End If
End Sub