If and Select Case Statements | Decoding VBA

Goal

Map status codes, thresholds, and categories using If and Select Case.

Example

Option Explicit

Function MapRegionCode(ByVal code As String) As String
    Select Case UCase(Trim(code))
        Case "E": MapRegionCode = "East"
        Case "W": MapRegionCode = "West"
        Case "C": MapRegionCode = "Central"
        Case Else: MapRegionCode = "Unknown"
    End Select
End Function

Next up

Repeat actions with For and For Each loops.

Back to Beginner lessons