Automating a Random Word Generator for Dyslexia Research

[MattNewby]

Hi,

I have with help a random word generator that creates a word from a list once the F9 key has been pressed.

Is there a away to make the generator cycle automatically?

I can live with a fixed cycle time say 8 seconds, though would ideally prefer a user definable input for cycle time.

Please advise

Matt

 

[SlamDunk]

You just need this line before the 'Next' in your 'For' loop

<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;">Application.Wait(Now + TimeValue("0:00:01"))
(Time is in H:MM:SS)

</code>Having variable time is a bit more complicated, unfortunately I'm in a hurry right now - but it is quite possible using VBA Dialog boxes. Good luck mate.

 

[MattNewby]

Thank,

That makes sense, but as of yet I have done all of the formula's in the front end.

I think I can use the send keys code to simulate pressing F9 in a Next for loop.

I will give it a try and thanks for your help.

Matt