Change what was entered

[bw]

I'd like to execute a macro each time a specific cell has been changed.

For example, if you enter something in cell D3, I want a macro to run.

Can someone lead the way?

Thanks,
Bernie

 

[Frank Kabel]

Hi
for this you may use the worksheet_change event procedure. See
http://www.cpearson.com/excel/events.htm
for more details

 

[bw]

Thanks again, Frank..

Bernie

Hi
for this you may use the worksheet_change event procedure. See
http://www.cpearson.com/excel/events.htm
for more details

 

[mudraker]

On the sheet module for the sheet you wish to change place this cod
replacing Do Something with your own code


Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$D$3" Then
do something
End If
End Su