Overflow!!!

[snip]

I write the follow code:

    Dim a As Double
    
    a = 20001 * 8

It will have overflow error, however, as 20001 * 8 = 160008, if I assign a directly to 160008, it will be fine, i.e.

   a = 160008

I think the problem is come from the * operator, but how could I solve this?? I really need to handle such a big value..

[Nucleus]

The explanation why the following works is here:
http://www.vbforums.com/showthread.p...274#post455274

The following will force the intermediate result to be held in a double:

Private Sub Command1_Click()
Dim a#
 
a = 20001# * 8
MsgBox a
End Sub

[beachbum]

Damn speed typist Nucleus

[Nucleus]

Not bad for a 2-4 finger typist .

[snip]

Thank Nucleus, it work now!!