Delay in formula

[Erol]

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

 

[Erol]

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.