The Integer data type is the most efficient way of handling numbers from -32,768 to 32,767 : Integer « Data Type « VBA / Excel / Access / Word






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

The Integer data type is the most efficient way of handling numbers from -32,768 to 32,767

 
Sub intDemo()
    Dim intMyVar As Integer
    For intMyVar = 1 To 300
        'repeat actions
    Next intMyVar
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.Overflow error