In this Excel VBA Tutorial we will learn about conditional IF THEN ELSE
ELSEIF statement. We will also learn about Application.InputBox as well
as, creating new line in msgbox and also adding Comenting and
uncomenting buttons in VBA.
The Microsoft Excel IF-THEN-ELSE statement used in VBA code returns a value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.
If condition_1 Then
result_1
ElseIf condition_2 Then
result_2
...
ElseIf condition_n Then
result_n
Else
result_else
End If
The Microsoft Excel IF-THEN-ELSE statement used in VBA code returns a value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.
If condition_1 Then
result_1
ElseIf condition_2 Then
result_2
...
ElseIf condition_n Then
result_n
Else
result_else
End If
0 comments:
Post a Comment