| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
random not truely random.
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
random not truely random.
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
random not truely random.
You can try this:
RandNum = Evaluate("=Rand()") -- Charles Chickering "A good example is twice the value of good advice." "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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting random Data created from a random formula | Excel Discussion (Misc queries) | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
| How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
| random | Excel Programming | |||
Linear Mode
