View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jake[_8_] Jake[_8_] is offline
external usenet poster
 
Posts: 1
Default Need code for simple change event

I want to run a simple If..Then based on a change to a range of cells
containing text. Basically something like this

If Range("E50:E100") changes Then
Range("A3") = Now()
End if

So if the text changes in the range the date of the document updates
to the system date. Seems like it should be simple but I can't figure
out how to do it. Any help appreciated.

Jake