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

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Data Type » Integer 
Overflow error
 

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

Sub macro_no_overflow()
  Dim 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
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.