Use If statement with Integer : Integer « Data Type « VBA / Excel / Access / Word






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

Use If statement with Integer

 
Sub ifTest()
    Dim intNum As Integer
    Dim strMessage As String

    intNum = 12

    If intNum > 10 Then
        strMessage = "The number is " & intNum
    End If

    Debug.Print strMessage

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.The Integer data type is the most efficient way of handling numbers from -32,768 to 32,767
8.Overflow error