vba random integer code example

Example: vba random number

Dim MyValue 
Randomize 		' Initialize random-number generator. 
MyValue = Int((6 * Rnd) + 1) ' Generate random value between 1 and 6.