Lord_WayneY
Lord_WayneY
Programming language:VBA
2021-04-10 14:47:17
0
Q:

vba rnd function

Aditya Tewatiya
Aditya Tewatiya
Code: VBA
2021-09-30 03:51:39 
'VBA has the Rnd() function which returns a random single floating point value
'between 0 and 1, but not including 1.

MsgBox Rnd		'<--displays something like 0.74323

'To generate values between two integer numbers, use the following formula:
'Int((max - min + 1) * Rnd + min)

'For example, to generate random integers between 11 and 14:
MsgBox Int((14 - 11 + 1) * Rnd + 11)    '<-- displays 11 or 12 or 13 or 14
6
Cesare
Cesare
Code: VBA
2021-04-04 18:19:08 
'VBA has the Rnd() function which returns a random single floating point value
'between 0 and 1, but not including 1.

MsgBox Rnd		'<--displays something like 0.74323

'To generate values between two integer numbers, use the following formula:
'Int((max - min + 1) * Rnd + min)

'For example, to generate random integers between 11 and 14:
MsgBox Int((14 - 11 + 1) * Rnd + 11)    '<-- displays 11 or 12 or 13 or 14
4

Tags

Related

New to Communities?

Join the community