Select Case statement with Integer value : 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 
Select Case statement with Integer value
 
Sub cmdCase_Click()
    Dim intAge As Integer
    intAge = 12
    Select Case intAge
      Case 0
        MsgBox "You Must Enter a Number"
      Case To 18
        MsgBox "You Are Just a Kid"
      Case 192021
        MsgBox "You are Almost an Adult"
      Case 22 To 40
        MsgBox "Good Deal"
      Case Is > 40
        MsgBox "Getting Up There!"
      Case Else
        MsgBox "You Entered an Invalid Number"
    End Select
End Sub

 
Related examples in the same category
1.Integer number
2.Local Integer variable
3.Add integer together
4.Input and Output
5.Add two numbers together
6.Use If statement with Integer
7.The Integer data type is the most efficient way of handling numbers from -32,768 to 32,767
8.Overflow error
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.