ConditinalStatements

If

Code Syntax

If <Condition> Then <Statement>

If <Condition> Then
   Statements1
Else
   Statements2
End if

If <Condition> Then
   Statements1
Else
   Statements2
End if

IIF

Code syntax

Function CheckIt (TestMe As Integer)
    CheckIt = IIf(TestMe > 1000, "Large", "Small")
End Function

Select Case

Code Syntax

Select Case Expression
    Case Expression1
    Statement1
    Case Expression2
        Statement2
    Case ExpressionN
        StatementN
End Select 

Multiple Cases

' https://excelmacromastery.com/
Public Sub Select_Case_Multi()

    Dim city As String
    ' Change value to test
    city = "Dublin"

    ' Print the name of the airport based on the code
    Select Case city
        Case "Paris", "London", "Dublin"
            Debug.Print "Europe"
        Case "Singapore", "Hanoi"
            Debug.Print "Asia"
        Case Else
            MsgBox "The city is not valid.", vbInformation
    End Select

End Sub