Overflow error?? 3

[Kryzsoccer]

Why will this return an overflow error:

Dim hello As Long
Private Sub Form_Load()
hello = 15 * 3 * 18 * 45
End Sub

but this will work fine:

Dim hello As Long
Private Sub Form_Load()
hello = 15 * 3
hello = hello * 18 * 45
End Sub

Are they not both doing the exact same thing??

As always, ALL help is appreciated!!

 

[Swi]

Check out MSDN:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vamsgoverflow.asp

Private Sub Form_Load()
Dim hello As Long
hello = CLng(15 * 3 * 18) * 45
MsgBox hello
End Sub

Swi

 

[ADoozer]

thats a very interesting point... which i never knew about.... a splat for you!!

If somethings hard to do, its not worth doing - Homer Simpson
------------------------------------------------------------------------
A General Guide To Excel in VB FAQ222-3383
The Great Date Debate Thread222-368305
File Formats Galore @

http://www.wotsit.org

or

http://www.filext.com

 

[Hypetia]

Casting the first element to Long will prevent the problems.
___
Dim hello As Long
hello = 15& * 3 * 18 * 45
Msgbox hello

 

[Kryzsoccer]

Thanks for all the help!!
In my program the numbers were actualy variables. I converted them all to longs and the problem was solved. Thanks for all your help!! Stars for both of you.
Chris