What causes the value of the cell to change?
Is it a DDE linked cell?
Is it a formula?
Is a selection from a listbox causing the change (then what about using the
change event of the listbox?)
What version of Excel?
Details would be important.
Also, if it is a listbox selection triggering the change, then what help do
you need?
--
Regards,
Tom Ogilvy
"Listbox use in Excel" wrote
in message ...
Hello:
I have a problem similar to the timed macro question earlier. I have a
macro
which I need to activate automaticalluy (without user intrervention)
whenever the value of a cell changes (For example - clear the contents of
a
specific range where the results would go).
Any help would be appreciated
thanks
manda