run marco when value in a cell changes

[bluefeather8989]

when D3 value (from Formula) changes run macro "Dealer". If D3 = 0 then nothing. the value will always be from 1-13.

 

[shg]

No event is triggered when a cell changes as a result of a formula. You would need to identify a cell that is manually changed that causes D3 to change.

 

[Smitty]

You could try the Calculate event:

<font face=Calibri><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Worksheet_Calculate()<br>    <SPAN style="color:#00007F">Dim</SPAN> rng <SPAN style="color:#00007F">As</SPAN> Range<br>    <br>    <SPAN style="color:#00007F">Set</SPAN> rng = Range("D3")<br>    <br>    <SPAN style="color:#00007F">If</SPAN> rng.Value > 0 And rng.Value < 14 <SPAN style="color:#00007F">Then</SPAN><br>        <SPAN style="color:#00007F">Call</SPAN> Dealer<br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br>    <br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

HTH,

 

[bluefeather8989]

You could try the Calculate event:

Private Sub Worksheet_Calculate()
Dim rng As Range

Set rng = Range("D3")

If rng.Value > 0 And rng.Value < 14 Then
Call Dealer
End If

End Sub

HTH,

This works exactly the way i need it to.THANK YOU. cheers