executing action only when cell has changed
"Tony" wrote in message
...
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
Tony,
Would nesting a if then else condition in a do while loop be possible for
your code? For example:
i=0
do while i 3
if i 14 then
' "Exit 'cause you're done"
else
Cells(4, i) = Cells(4, i - 1) + 7
i=i+1
loop
|