Random an array

[whcmelvin]

hi, i would like to know how to random an array. for example, the array values is burger king, mac and long john sliver. how do i make one of it appear when i click on a button and the values will appear on msg box.the program should random the values. thanks.

 

[Rick Rothstein]

Something like this should work. Create your array...

MyArray = Array("burger king", "mac", "long john sliver")

Then get one at random...

RandomIndex = Int((UBound(MyArray) - LBound(MyArray) + 1) * Rnd + LBound(MyArray))
MsgBox MyArray(RandomIndex)

Note: The expression I used in the assignment to the RandomIndex variable came from help files for the Rnd function.