Oct 08 2021 08:36 AM
Hello ...
This may be wishful thinking but I would much appreciate being made aware of a solution if one exists.
I have created a dictionary of Welsh/English words and am using this to test myself as to the meaning of the former. For this purpose my spreadsheet has two adjacent columns as shown below.
In Column E the formula used is INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1) while the formula in Column G is INDEX($C$6:$C$600,MATCH($E$2,$A$6:$A$600,0)). Is there a way in which the answer displayed in Column G can be delayed by, say, 30 seconds.
Would appreciate any recommendations and thanks in advance.
Regards
James Clancy
Oct 08 2021 10:58 AM
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.
Oct 09 2021 12:54 AM
Oct 09 2021 02:31 AM
SolutionHere 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.
Oct 09 2021 02:59 AM
Oct 09 2021 03:31 AM - edited Oct 09 2021 03:34 AM
@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
Oct 10 2021 01:35 AM
Oct 09 2021 02:31 AM
SolutionHere 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.