Use Integer as the switch value for Select Case Structure : Select « Language Basics « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Language Basics
  3. Select

Use Integer as the switch value for Select Case Structure

 
Sub ifTest5()
      Dim intNum As Integer
      intNum = 2
      Select Case intNum
      Case 1
            Debug.Print "This is the lowest number"
      Case 15
            Debug.Print "This is the highest number"
      Case Else
            Debug.Print "The number is between 1 and 15"
      End Select
End Sub








Related examples in the same category

1.Use select case statement
2.Use string text as the select case statement control value
3.Specifying a Range of Values in a Case Clause by using the To keyword between the values of expressions
4.Select Case Statements with comparison operator
5.Specify a range in select case statement
6.Specifying Multiple Expressions in a Case Clause: specify multiple conditions within a single Case clause by separating each condition with a comma
7.Using Is with the Case Clause
8.Select Case Else
9.A nested Select Case example
10.Three-level nested Select Case statement
11.Convert number to String by using Select statement
12.Choosing Actions with Select Case