View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default random not truely random.

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?