Library tutorials & articles

If...Then...Else statement

Syntax

It can be used in either a single line syntax or a multiple line "Block" syntax:

Syntax 1:
If condition1 Then statement

---Or---

Syntax 2:
If condition1 Then
   statement
End If

The following code is an example:

If AnyDate < Now Then AnyDate = Now

---Or---

If AnyDate < Now Then
   AnyDate = Now
   Msgbox "Today is " & AnyDate
End If

Note that if you use the single line syntax you do not need the End If statement. If you want to execute more than one line of code when the condition is True, you must use the multiple line block syntax.

You can use the If...Then...Else syntax to define a block of statements, one of which will always be run. It uses the following syntax:

If condition1 Then
   statement
Else
   statement
End If

You can use the ElseIf statement to test several conditions. This replaces the need for several If...Then statements, making your code shorter and easier to read. It uses the following syntax:

If condition1 Then
   statement
ElseIf condition2 Then
   statement
Else
   statement
End If

Comments

  1. 24 Sep 2008 at 13:50

    in if else control structutre what will be the syntax for the condition for greatest of three numbers

  2. 01 Jan 1999 at 00:00

    This thread is for discussions of If...Then...Else statement.

Leave a comment

Sign in or Join us (it's free).

James Crowley James first started this website when learning Visual Basic back in 1999 whilst studying his GCSEs. The site grew steadily over the years while being run as a hobby - to a regular monthly audience ...

Related discussion

Related podcasts

  • Christian Beauclair

    14 mai 2008 (�mission #0074) ::.Christian Beauclair: Stratégies de migration VB6 vers .NET Nous discutons avec Christian Beauclair des stratégies de migration VB6 vers .NET. Entre autres, nous discutons comment utiliser le "VB 6 Code Advisor" et le "Interop Forms Toolkit" pour ajouter la puiss...

Want to stay in touch with what's going on? Follow us on twitter!