Overflow error : Integer « Data Type « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type
  3. Integer

Overflow error

 

Sub macro_overflow()
  Dim l As Integer
  l = 255 * 256   'overflow error
End Sub

Sub macro_no_overflow()
  Dim l As Long
  l = 255& * 256  'now it works
End Sub








Related examples in the same category

1.Integer number
2.Local Integer variable
3.Add integer together
4.Select Case statement with Integer value
5.Input and Output
6.Add two numbers together
7.Use If statement with Integer
8.The Integer data type is the most efficient way of handling numbers from -32,768 to 32,767