View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
 
Posts: 915
Default 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.