VBA Event Handler for specific cell changes

[s0up2up]

Hey guys,

Like the question states, is there an even handler that will enact a macro if a value is entered into a specific cell?

Cheers for any help!

Cheers,
s0up2up

 

[s0up2up]

How would that look for a range?

ucase(range("A1")) = "YES"

?

 

[repairman615]

Ucase(Range("A1").value) = "YES"





<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> tst()<br><br>Range("A1").Value = "Yes"<br><br><br>MsgBox UCase(Range("A1").Value) = "YES"<br><br><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>






I thought you may be using data validation, it most likely helps keeping the data consistant.

 

[arungoogol]

works like charm, Thank you very much