VBA OR Function

VBA OR Function

Objective of VBA OR Function

VBA OR function is categorized as a logical function in VBA. It is a built-in function in MS Office Excel VBA. This function returns true, if any of the conditions are TRUE. This function is used to combine more than one condition with using ‘OR’ keyword. This is one of the most used logical operator. It has minimum two conditional input parameters to check. It returns a Boolean value (True or False).

We can use this function as a worksheet function and also can be used in VBA. This function can be used in either procedure or function in a VBA editor window in Excel. We can use this VBA OR function any number of times in any number of procedures or functions. In the following section we learn what is the syntax and parameters of the OR function, where we can use this VBA OR function and real-time examples.

Syntax of VBA OR Function

The syntax of the VBA OR function is

Condition1 OR Condition2
'or
Condition1 OR Condition2 [...OR ConditionN]

The VBA OR function returns Boolean value either True or False. It returns TRUE, if any of the conditions are TRUE. Otherwise returns FALSE.

Parameters or Arguments

The OR function has one input parameter or argument.
Where
Condition1 & Condition2: Both are required parameters. Here we evaluate specified any of the conditions are true or not.

Where we can apply or use VBA OR Function?

We can use this VBA OR function in MS Office 365, MS Excel 2016, MS Excel 2013, 2011, Excel 2010, Excel 2007, Excel 2003, Excel 2016 for Mac, Excel 2011 for Mac, Excel Online, Excel for iPhone, Excel for iPad, Excel for Android tablets and Excel for Android Mobiles.

Example 1: Check any of the conditions are true or not(TRUE)

Here is a simple example of the VBA OR function. This below example macro checks any of the specified conditions. The output of below macro is TRUE.

'Check two conditions are true or not
Sub VBA_OR_Function_Ex1()

    If (1 = 1) Or (5 = 5) Then
            MsgBox "Specified conditions are : TRUE ", vbInformation, "VBA OR Function"
        Else
            MsgBox "Specified conditions are : FALSE ", vbInformation, "VBA OR Function"
    End If
    
End Sub

Output: Here is the screen shot of the first example output.
VBA OR Function

Example 2: Check any of the conditions are true or not(FALSE)

Here is a another example of the VBA OR function. This below example macro checks any of the specified conditions. The output of below macro is FALSE.

'Check two conditions are true or not
Sub VBA_OR_Function_Ex2()

    If 11 > 12 Or 12 > 13 Then
            MsgBox "Specified conditions are : TRUE ", vbInformation, "VBA OR Function"
        Else
            MsgBox "Specified conditions are : FALSE ", vbInformation, "VBA OR Function"
    End If
    
End Sub

Output: Here is the screen shot of the second example output.
VBA OR Function

Example 3: Check any of the conditions are true or not(TRUE)

Here is a simple example of the VBA OR function. This below example macro checks any of the specified conditions. The output of below macro is TRUE.

'Check more than two conditions are true or not
Sub VBA_OR_Function_Ex3()

    If (1 = 1) Or (2 = 2) Or (3 = 3) Then
            MsgBox "Specified conditions are : TRUE ", vbInformation, "VBA OR Function"
        Else
            MsgBox "Specified conditions are : FALSE ", vbInformation, "VBA OR Function"
    End If
    
End Sub

Output:Here is the screen shot of the third example output.
VBA OR Function

Instructions to use Macro Codes

Here are the step by step instructions to use the VBA OR function in Excel VBA.

  • Open an Excel workbook.
  • Press Alt+F11 to open VBA Editor window.
  • Go to Insert menu and click on module from the available options.
  • Copy above specified macros to the VBA editor.
  • Select any procedure from above codes and click on ‘Run’ command or use Keyboard shortcut ‘F5’.

List of VBA Functions:

Please click on below link to go back to see all List of VBA Functions.

VBA Logical Functions List of VBA Functions

Leave a Comment

Your email address will not be published. Required fields are marked *