scott_n_phnx
Active Member
- Joined
- Sep 28, 2006
- Messages
- 445
I am working on a macro that will "randomly" choose between 6 values. The code that I have works so far, but I want to see if there is a way to set how often certain numbers occur. I want the higher numbers to occur less often. Any help would be appreciated. Here is what I have:
Code:
Sub Randomize()
Dim intLowNumber As Integer
Dim intHighNumber As Integer
Dim intNumber As Integer
Dim intValue As Integer
intLowNumber = 1
intHighNumber = 6
'Randomize
intNumber = Int((intHighNumber - intLowNumber + 1) * Rnd + intLowNumber)
Select Case intNumber
Case 1
intValue = "400"
Case 2
intValue = "600"
Case 3
intValue = "800"
Case 4
intValue = "1000"
Case 5
intValue = "1200"
Case 6
intValue = "2000"
End Select
Sheet1.TextBox1.Value = intValue
End Sub