If Then Else with multiple statements after Then

Question

a very easy question  considering an If   Then   Else instruction in VBA  how can I separate multiple instructions after Then  In other words  should I write something like  If condition   Then            statement1    amp   statement2   Else  Else statement   i e  using   amp       or  If condition   Then                 statement1   And  statement2   Else  Else statement   i e  using  And      or some other separator command

User · Accepted Answer

Multiple statements are to be separated by a new line   If SkyIsBlue Then   StartEngines   Pollute ElseIf SkyIsRed Then   StopAttack   Vent ElseIf SkyIsYellow Then   If Sunset Then     Sleep   ElseIf Sunrise or IsMorning Then     Smoke     GetCoffee   Else     Error   End If Else   Joke   Laugh End If

User · Answer

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 stmt2 Else if condition2 Then stmt3 stmt4 Else stmt5 stmt6

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

Examples related to vba

Examples related to if-statement

Examples related to conditional-statements