Conditions are vital parts of any application as this is usually what drives the logic of an application.
There are multiple options available in Visual Basic to execute certain code based on the condition
This is the most common way to decide if the code within the If statement body should be executed. If statement simply evaluates the expression to Boolean True or False and executes the code if expression is True. This means that all expressions must result in either True or False value
If True Then Debug.Print "Always Prints" End If
However the following code will result in the runtime exception as String value cannot be cast to Boolean
If "A" Then End If
while the following snippet is valid as comparison of 2 String values results into the Boolean value
If "A" = "A" Then End If
It is possible to specify the fallback value for the statement, i.e. block of code which should be executed if the main condition is False
If myVar > 10 Then Debug.Print "Value of myVar variable is greater than 10" Else Debug.Print "Value of myVar variable is lower than 10" End If
It is possible to specify multiple conditions as well as combine the expressions with logical operations
If myVar < 0 Then Debug.Print "myVar has a negative value" ElseIf myVar = 0 Then Debug.Print "myVar equals to 0" ElseIf myVar > 0 And myVar < 10 Then Debug.Print "myVar value in a range of 0...10 (exclusive)" Else Debug.Print "Value of myVar is 10 or more" End If
Conditions are executed one-by-one until the True condition is found
If it is required to perform the check against multiple constant values, instead of using If-ElseIf it is possible to use Select Case. Although, Select Case can be considered redundant to If-ElseIf, it is widely used as it allows to create a simple, more readable code. Select Case statement also supports fallback value using the Case Else statement.
The below code converts the position of the day in the week to its text representation. It throws an error if the specified value is outside of 1-7 range as this would be an invalid input.
Select Case dayOfTheWeek Case 1 Debug.Print "Monday" Case 2 Debug.Print "Tuesday" Case 3 Debug.Print "Wednesday" Case 4 Debug.Print "Thursday" Case 5 Debug.Print "Friday" Case 6 Debug.Print "Saturday" Case 7 Debug.Print "Sunday" Case Else Err.Raise vbError, "", "Value outside of the 1...7 range" End Select
Visual basic supports 3 logical operators: And, Or and Not
- Result of And operators will be equal to True if all of its arguments are equal to True
- Result of Or operators will be equal to True if at least one of its arguments is equal to True
- Not operator reverses the value
Operators can be grouped with parenthesis to define the order of operations
Dim varA, varB, varC, varD As Boolean varA = True varB = False varC = True varD = False Debug.Print varA And varB 'False Debug.Print Not (varA And varB) 'True Debug.Print varA And varC 'True Debug.Print varA Or varC 'True Debug.Print varA Or varB 'True Debug.Print varB Or varD 'False Debug.Print (varA Or varB) And varD 'False Debug.Print varA Or (varB And varD) 'True
The following table demonstrates the results based on the values and operator