• Home
 · 
• Miscellaneous
 · 
• Mysterious Overflow Problem

Mysterious Overflow Problem

One day, I was performing calculation on numeric variables.I kept getting error message "Overflow" so I checked my variable declaration, it's declared as Long, but the operation of the two numeric values gave 2500. I was confused at first, finally I brought up MSDN help and discovered the solution.

Rate Mysterious Overflow Problem

• 1
• 2
• 3
• 4
• 5

(7(7 Vote))

This will generate an error message "Overflow"
Sub Command1_Click()
Dim X As Long
X = 2000 * 350
End Sub
'This is the solution I got from MSDN.
Sub Command1_Click()
Dim X As Long
X = CLng(2000) * 350 Or
X = 2000 * CLng(350)
End Sub