Overflow!!!

I write the follow code:

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.

Code:

---

  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..
:confused:

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:

VB Code:

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

Damn speed typist Nucleus :p

Not bad for a 2-4 finger typist :D.

Thank Nucleus, it work now!! :D