If...Then...Else with multiple statements after Then If...Then...Else with multiple statements after Then vba vba

If...Then...Else with multiple statements after Then


Multiple statements are to be separated by a new line:

If SkyIsBlue Then  StartEngines  PolluteElseIf SkyIsRed Then  StopAttack  VentElseIf SkyIsYellow Then  If Sunset Then    Sleep  ElseIf Sunrise or IsMorning Then    Smoke    GetCoffee  Else    Error  End IfElse  Joke  LaughEnd If


This works with multiple statements:

if condition1 Then stmt1:stmt2 Else if condition2 Then stmt3:stmt4 Else stmt5:stmt6

Or you can split it over multiple lines:

if condition1 Then stmt1:stmt2Else if condition2 Then stmt3:stmt4Else stmt5:stmt6