See Chip Pearson's page on using Application.Ontime

http://www.cpearson.com/excel/ontime.htm

for starting with code:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


to generate a random number between 1 and 10

Range("B9").Value = int(rnd()*10+1)

--
Regards,
Tom Ogilvy


"gatesheadthunde"
<gatesheadthunde.1zmyxb_1133902212.0529@excelfor um-nospam.com wrote in
message news:gatesheadthunde.1zmyxb_1133902212.0529@excelf orum-nospam.com...

Hi,

Just wondering how I can create a whole number between 1 and 10 every 2
seconds for 2 minutes on the press of a button?

The number will paste in to cell A1 and be overwritten every 2 seconds
when a number is generated?

I'm quite new to VBA with Excel so if anyone can recommend some free
easy to understand tutorials, please let me know.

Thanks :)


--
gatesheadthunde
------------------------------------------------------------------------
gatesheadthunde's Profile:
http://www.excelforum.com/member.php...o&userid=10536
View this thread: http://www.excelforum.com/showthread...hreadid=491199