Forum Discussion
Creating a time delayed answer
Here is the example file with the code and how it is used.
It's just a trick in which you can create a time delay.
It could possibly also be displayed with a formula in which other calculations are carried out between input and output (in simple terms), but the circular reference errors, as well as other possible errors, would prevent me from doing so. But that's just my humble opinion:)).
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Iriwel, it may be late but here is my workaround without macros and with iterative calculation. Yes, with the annoying circular references that we dislike so much if they are not properly controlled.
You can modify the number of seconds in cell I2.
You need to repeatedly press the F9 key to iteratively calculate the formulas.
Regards,
Pedro Wave
- Pedro ...
Many thanks for this very helpful solution. I'll try it out over the next few days alongside an earlier suggestion from NicolinoDE.
Also, thanks for the inclusion of additional vocabulary - that really impressed me.
Regards.
