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




0 comments:

Post a Comment

 
Top