View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tony tony is offline
external usenet poster
 
Posts: 313
Default executing action only when cell has changed

I want to create code to run simple procedure only when the triggering cell
will change. I have tried all suggestions (Worksheet_Change event) found on
this newsgroup and nothing works for me. Please help.

I want the code:

For i = 3 To 14
Cells(4, i) = Cells(4, i - 1) + 7
Next i

to be executed only when the value in the cell B4 will be changed by user -
new value entered.

Thanks for help.

Tony