Execute a macro when a cell changes

[imported_unknown]

I have a cell in my spreadsheet that contains a link where the value is continually changing. Whenever the value changes I need a macro to automatically execute. How can I achieve this?

thank you

 

[Damon Ostrander]

Hi J,

You can trap such a change via the use of the worksheet's Calculate event. I assume you do not want to run your macro if the cell is updated, but only if its value changes. If so, here's a sample macro that does this:

Dim LastVal As Variant

Private Sub Worksheet_Calculate()
If LastVal = Empty Then
LastVal = [a1].Value
Else
If [a1].Value <> LastVal Then
Call YourMacro()
LastVal = [a1].Value
End If
End If
End Sub

This example is for cell A1. You must place this code in the worksheet's event code module. To do this, right-click on the worksheet's tab, select View Code, and paste the code into the VBE code pane.

 

[Fryer Tuck]

Try this one on the sheet's event page:

Private Sub Worksheet_Change(ByVal Target As Range)
If target = address of the cell you want to keep an eye on Then
Do whatever is is you want done
End if
End Sub

F.T.