To prevent repetitive sequences, use the Randomize statement to initialize the random number generator with a seed value based on the system clock. : Rnd « Math Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Math Functions
  3. Rnd

To prevent repetitive sequences, use the Randomize statement to initialize the random number generator with a seed value based on the system clock.

 
Sub intDemo()
    Dim val1
    Randomize
    val1 = Int(100 * Rnd + 1)
End Sub








Related examples in the same category

1.Rnd([number]) returns A random number (with no argument) or a number based on the given initial seed.
2.Rnd() Returns a random number between 0 and 1.