Randomize number 1

[scottian]

How can i create a random number within a loop. so the random number is created for each loop.

"My God! It's full of stars...

 

[IknowMe]

From th EB help files

'Randomize statement to generate a seed for the Rnd function.

Randomize                      ' Seed random number generator.
Dice1% = Int(6 * Rnd + 1)      ' Generate first die value.
Dice2% = Int(6 * Rnd + 1)      ' Generate second die value.
Msg$ = "You rolled a " + LTrim$(Str$(Dice1%))
Msg$ = Msg$ + " and a " + LTrim$(Str$(Dice2%))
Msg$ = Msg$ + " for a total of "
Msg$ = Msg$ + LTrim$(Str$(Dice1% + Dice2%)) + "."
MsgBox Msg$                    ' Display message.

Wow, I'm having amnesia and deja vu at the same time.
I think I've forgotten this before.

 

[scottian]

Brilliant

"My God! It's full of stars...