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.
Here is an approach to a solution with VBA.
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$G$2" Then
Application.OnTime Now + TimeValue("00:00:03"), "Show"
End If
End Sub
Hope I was able to help you with this info.
NikolinoDE
Was the answer useful? Mark them as helpful!
This will help all forum participants.
- Hello ...
Many thanks for your prompt reply to my query. I loaded the VBA (Alt/F11) with your solution but, unfortunately, it doesn't seem to be behaving as it should. Am I missing a trick somewhere?
Regards.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.
- Got it. Thank you so much for your help.
Regards
