Trigger VBA routine if ceel content changes
 

I need to trigger a VBA routine when the content of one specific cell in a
sheet changes. Can anybody point me in the right direction?
Thanks for your time.
Daniel

Trigger VBA routine if ceel content changes
 

You will need to use the Worksheets Change Event .... Right click the
sheet tab name
and select View Code....

Paste code something like

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
RunYourMacroName
End If
End Sub

Just change the cell Address you need to monitor the change in.


--
Ivan F Moala


------------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...fo&userid=1954
View this thread: http://www.excelforum.com/showthread...hreadid=273093

Trigger VBA routine if ceel content changes
 

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then
With Target
'do something
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.



--

HTH

RP

"Daniel Van Eygen" wrote in message
i.nl...
I need to trigger a VBA routine when the content of one specific cell in a
sheet changes. Can anybody point me in the right direction?
Thanks for your time.
Daniel