VBA if statements: using control structures to make decisions

 If condition = True Then
   ...the code that executes if the condition is satisfied
End If

If condition = True Then
   Msgbox "The condition is true!"
End If
If condition = False Then
   Msgbox "The condition is false!"
End If

If condition = True Then
   ...this is the code that executes if the condition is satisfied
Else
   ...this is the code that executes if the condition is not satisfied
End If

If condition1 = True Then
   ...the code that executes for condition1
ElseIf condition2 = True Then
   ...the code that executes for condition2
ElseIf condition3 = True Then
   ...the code that executes for condition3
Else
   ...the code that executes if none of the above are true
End If

Select Case test_expression
   Case expression-1
      ...this is the code that executes if expression-1 matches test_expression
   Case expression-2
      ...this is the code that executes if expression-2 matches test_expression
   Case expression-3
      ...this is the code that executes if expression-3 matches test_expression
   Case Else
      ...this is the code that executes if expression-n matches test_expression
End Select

Select Case State
   Case "Michigan"
      Message = "Michigan is a wonderful state to visit if you enjoy fresh-water lakes."
   Case "Virginia"
      Message = "Visit the Commonwealth for a wide variety of historical landmarks and beautiful mountain-scapes."
   Case "Arizona"
      Message = "Arizona is a wonderful getaway for those who love heat with low humidity"
   Case "Colorado"
      Message = "Colorado is almost unsurpassed for its majestic mountains and rivers."
   Case Else
      Message = "No specific information is available about this state."
End Select