Automating a Random Word Generator for Dyslexia Research

MattNewby

Board Regular
Joined
Dec 15, 2009
Messages
155
Hi,

I have with help a random word generator that creates a :rolleyes: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

:rolleyes:
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

SlamDunk

New Member
Joined
Jun 10, 2015
Messages
8
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.
 
Upvote 0

MattNewby

Board Regular
Joined
Dec 15, 2009
Messages
155
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
 
Upvote 0

Forum statistics

Threads
1,195,938
Messages
6,012,416
Members
441,698
Latest member
DaveTeo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top