Select « Language Basics « VBA / Excel / Access / Word

1.Use Integer as the switch value for Select Case Structure
2.Use select case statement
3.Use string text as the select case statement control value
4.Specifying a Range of Values in a Case Clause by using the To keyword between the values of expressions
5.Select Case Statements with comparison operator
6.Specify a range in select case statement
7.Specifying Multiple Expressions in a Case Clause: specify multiple conditions within a single Case clause by separating each condition with a comma
8.Using Is with the Case Clause
9.Select Case Else

10.A nested Select Case example
11.Three-level nested Select Case statement
12.Convert number to String by using Select statement
13.Choosing Actions with Select Case