Delay in formula
Erol wrote:
Hi All,
I want execute a formula with a delay. For example, In cell A2 I enter
=if(A1=3,good, bad)
So when I enter 3 in cell A1 I don't want A2 cell to display good
immediately. Can I make it execute after 1 second, or even less 1/10 second?
Please let me know if you have any ideas.
Thanks in advance
You will need VBA for this, and I'm not sure it's a great idea since you
will basically need to "stun up" Excel for the delay period... could be
very frustrating and confusing for a user.
My question is "why?". Maybe there's a better way.
But it's your project. If you are still interested, let us know.
|