# run marco when value in a cell changes

#### bluefeather8989

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

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
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.

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,

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

Replies
1
Views
129
Replies
23
Views
584
Replies
2
Views
221
Replies
2
Views
373
Replies
10
Views
686

1,203,460
Messages
6,055,556
Members
444,796
Latest member
18ecooley

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back