VBA IF Statements: Can you have multiple actions in the "Then" area?

[clawlan]

I can't figure out how to have multiple actions occur in the "Then" area of a VBA IF statement. I am trying to set 2 different variables based on the result of an if statement:

If var1 = apple then
var2 = 0 AND var3 = 1
elseif...
...
endif

What am I missing?

 

[repairman615]

Hello, maybe something like:

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> example()<br><br>    <SPAN style="color:#00007F">If</SPAN> <SPAN style="color:#00007F">True</SPAN> = <SPAN style="color:#00007F">True</SPAN> <SPAN style="color:#00007F">Then</SPAN><br>        var1 = 1<br>        var2 = 2<br>    <SPAN style="color:#00007F">Else</SPAN><br>        <br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN><br><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[clawlan]

Hello, maybe something like:

Sub example()

If True = True Then
var1 = 1
var2 = 2
Else

End If

End Sub

Wow, makes me feel dumb. Thanks!

 

[repairman615]

Your welcome, You can do many actions within the If statement. In other words you may have multiple lines of code doing different things for the THEN and/or ELSE portions of the IF. It is not limited to only one action.

 

[Ruddles]

See if this helps: http://www.mrexcel.com/forum/showpost.php?p=2583885&postcount=4