Delay in formula
 

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

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.

Delay in formula
 

Its just a indirect solution to what I have been trying to do.

I was trying to connect 4 check boxes with a option button. If any of the
check boxes were selected than the option button had to go off. If non of the
check boxes were selected option button had to go on. I generated a huge if
formula for the option button's linked cell. But the problem was, when
someone clicked on the option button the formula would be erased. I finally
found out that I could disable the option button's clickability. So the
problem is solved now.

The reason why I asked this from you was, I wanted another cell to change
the formula (or data) inside the option button's linked cell. But it had to
happen in 0.001 second after.

Regadless, Thank you for your help.

"smartin" wrote:

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.