Rnd Function
реж рд░ рез рдХреЛ рдмреАрдЪрдорд╛ рдЕрдирд┐рдпрдорд┐рдд рдирдореНрдмрд░рд╣рд░реВ рдлрд░реНрдХрд╛рдЙрдБрдЫ ред
рд╡рд╛рдХреНрдп рд╕рдВрд░рдЪрдирд╛:
Rnd [(рдЕрднрд┐рд╡реНрдпрдХреНрддрд┐)]
рдорд╛рди рдлрд░реНрдХрд╛рдЙрдиреБрд╣реЛрд╕реН:
рдбрдмрд▓
рдкрд░рд╛рдорд┐рддрд┐рд╣рд░реВ:
Expression: Has no effect, is ignored if provided.
The Rnd function returns decimal fractions ranging from 0 (included) to 1 (excluded) according to a uniform distribution. It uses the Mersenne Twister 19937 random-number generator. To generate random integers in a given range, use a formula like in the example below. A Randomize statement with a defined seed value can be used beforehand, if a predictable sequence of numbers is desired.
рдЙрджрд╛рд╣рд░рдг:
Sub ExampleRandomSelect
Dim iVar As Integer
iVar = Int((15 * Rnd) -2)
Select Case iVar
Case 1 To 5
рдореБрджреНрд░рдг рдЧрд░реНрдиреБрд╣реЛрд╕реН "Number from 1 to 5"
Case 6, 7, 8
рдореБрджреНрд░рдг рдЧрд░реНрдиреБрд╣реЛрд╕реН "Number from 6 to 8"
Case Is > 8 And iVar < 11
рдореБрджреНрд░рдг рдЧрд░реНрдиреБрд╣реЛрд╕реН "Greater than 8"
Case Else
рдореБрджреНрд░рдг рдЧрд░реНрдиреБрд╣реЛрд╕реН "Outside range 1 to 10"
End Select
End Sub