Wow, I love it when there is an easy fix for something.

Thanks much Tom, you have a lot of great solutions on this board..

"Tom Ogilvy" wrote:

randomize
CurrPick = Int((54 * Rnd) + 1)

--
Regards,
Tom Ogilvy


"Kevin" wrote:

I'm using this...
CurrPick = Int((54 * Rnd) + 1)
but it is not random. every time you restart the userform the same sequence
of random numbers comes up.

Is there a way to get a truely random number that wont repeat every time you
activate the user form?