Sub Math Probability Class

RandomDoubleTest

Signature (Visual Basic / VBA)

Private Sub RandomDoubleTest()
    'Test the RandomDouble function.

    Const lngTries = 20000000

    Dim dblMin#, dblMax#, lngCur&, dblTmp#

    dblMin = RandomDouble
    dblMax = dblMin

    Debug.Print Now
    For lngCur = 1 To lngTries
        dblTmp = RandomDouble
        If dblTmp < dblMin Then dblMin = dblTmp
        If dblTmp > dblMax Then dblMax = dblTmp
        If lngCur Mod 10000000 = 0& Then Debug.Print Now, Format$(lngCur, "#,##0")
    Next lngCur
    
    Debug.Print "Min: " & dblMin
    Debug.Print "Max: " & dblMax
End Sub