Overflow problems!

Apocolypse2005 · September 2nd, 2007, 04:16 PM

What variable type could hold 6 digits, because integers don't and longs don't?

Code:

Round(Sin(Rnd()), 6)

That code returns a 6 digit number and i just need to store it in variable that isn't a string.

Thanks

------------------------------------------------
Apocolypse2005
Always ready and waiting to be helped!

Shasur · September 2nd, 2007, 11:26 PM

You can use Double

Sub No()
Dim dbl As Double

dbl = Round(Sin(Rnd()), 6)
End Sub

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

BrianWren · September 4th, 2007, 10:51 AM

Actually, a Long can.
I put the following into VB 6 as a test.
Read the comments for the behavior:

Code:

Private Sub Form_Click()

    Dim L As Long
        L = 999999
        L = 9999999
        L = 99999999
        L = 999999999         ' In fol. stmts, VB supplied the â#â
        L = 9,999,999,999#    ' <ââ<<< This was where the o-flow occurred.
        L = 99999999999#      ' (I added the commas for clarity.)
        L = 999999999999#     ' It didn't fail till 10 digits.
        . . .