random not truely random.

[Guest]

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?

 

[Guest]

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

 

[Guest]

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..

 

[Guest]

You can try this:
RandNum = Evaluate("=Rand()")