VBA Boolean

Updated on January 1, 2024
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Excel VBA Boolean Operator

Boolean is a data type. It is also a built-in data type in VBA. This data type is used for logical references or logical variables because the value this data type holds is either TRUE or FALSE, used for logical comparison. The declaration of this data type is similar to all the other data types.

As we said, the Boolean data type can hold either TRUE or FALSE as the data, but it can also hold number 1 as TRUE and 0 as FALSE. So, TRUE is represented by 1, and FALSE is represented by 0. So, when we declare the variable as BOOLEAN, it occupies 2 bytes of computer memory.

VBA Boolean

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: VBA Boolean (wallstreetmojo.com)

Working with Boolean Data Type in VBA Programming Language

Let us see the example of setting Boolean operator values to variables using the VBA CodeUsing The VBA CodeVBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task.read more.

You can download this VBA Boolean Data Type Excel Template here – VBA Boolean Data Type Excel Template

Follow the steps below to gain adequate knowledge of Boolean data types in VBA.

Step 1: First, start the subprocedure by naming the macro name.

Code:

Sub Boolean_Example1()

End Sub
VBA Boolean Example 1

Step 2: Declare the variable as “BOOLEAN.”

Code:

Sub Boolean_Example1()

  Dim MyResult As Boolean

End Sub
VBA Boolean Example 1-1

Step 3: Now, for the variable “MyResult,” apply the simple logical testLogical TestA logical test in Excel results in an analytical output, either true or false. The equals to operator, “=,” is the most commonly used logical test.read more as 25 > 20.

Code:

Sub Boolean_Example1()

  Dim MyResult As Boolean

  MyResult = 25 > 20

End Sub
VBABoolean Example 1-2

Step 4: Now, show the result in a message box in VBAMessage Box In VBAVBA MsgBox function is an output function which displays the generalized message provided by the developer. This statement has no arguments and the personalized messages in this function are written under the double quotes while for the values the variable reference is provided.read more.

Code:

Sub Boolean_Example1()

  Dim MyResult As Boolean

  MyResult = 25 > 20

  MsgBox MyResult

End Sub
VBA Boolean Example 1-3

Now, run the excel macroExcel MacroA macro in excel is a series of instructions in the form of code that helps automate manual tasks, thereby saving time. Excel executes those instructions in a step-by-step manner on the given data. For example, it can be used to automate repetitive tasks such as summation, cell formatting, information copying, etc. thereby rapidly replacing repetitious operations with a few clicks. read more through the F5 key or manually and see the result.

VBA Boolean Example 1-4

We got the result as TRUE because the number 25 is greater than the number 20, so the logical test is correct, and the result is TRUE.

It is the basic structure of VBA Boolean data types.

–>> If you want to learn Excel VBA professionally, then our VBA Basic Course (16+ hours) is the perfect solution. In our Basic Excel VBA course you learn the skill of automating tasks using Variables, Data Types, Ranges, and Cells in VBA. Master Control Structures, including Conditional Statements and Loops, and discover techniques for manipulating data through sorting, filtering, and formatting. By the end of the course, you will be able to apply your acquired skills to real projects, culminating in an Excel VBA project which will solidify your ability to create efficient, automated solutions.

Boolean Data Type Cannot Hold Other than TRUE or FALSE.

VBA Boolean is a logical data type. It holds either TRUE or FALSE. Anything other than TRUE or FALSE will show an error message as “Type Mismatch” in VBA.

For example, look at the below code.

Code:

Sub Boolean_Example2()

  Dim BooleanResult As Boolean

  BooleanResult = "Hello"

  MsgBox BooleanResult

End Sub
VBABoolean Example 2

In the above code, we have declared the variable “BooleanResult” as Boolean.

 Dim BooleanResult As Boolean

In the next line, we have assigned the value to the declared variable as “Hello.”

BooleanResult = "Hello"

We have declared the variable as Boolean, but we have assigned the value as “Hello,” which is other than logical values: TRUE or FALSE.

When we run this code using the F5 key or manually, we will get the type mismatch error because of the data type mismatch value.

VBA Boolean Example 2-1

All the Numbers are TRUE, and Zero is FALSE

As we said, TRUE is represented by the number 1, and FALSE is represented by 0. For example, look at the below code in VBA.

Code:

Sub Boolean_Example3()

    Dim BooleanResult As Boolean

    BooleanResult = 1

    MsgBox BooleanResult

End Sub
VBABoolean Example 3

We assigned the value to the variable as 1, showing the result as TRUE.

VBA Boolean Example 3-1

Now, look at the code below.

Code:

Sub Boolean_Example3()

    Dim BooleanResult As Boolean

    BooleanResult = 0

    MsgBox BooleanResult

End Sub
VBABoolean Example 3-2

In this code, we have assigned the value to the variable as 0, showing the result as FALSE.

VBA Boolean Example 3-3

Not only 1 or 0, but it can also treat any number assigned to the variable except zero as TRUE. It will only treat zero as 1.

VBA Boolean Operator with IF Condition

Since the Boolean data type can hold only logical values, it is best suited to use with the IF condition in VBA.

Code:

Sub Boolean_Example2()

   Dim Number1 As Integer
   Dim Number2 As Integer

   Number1 = 80
   Number2 = 75

   If Number1 >= Number2 Then
       MsgBox True
   Else
       MsgBox False
  End If

End Sub
VBABoolean Example 4

Like this, we can use Excel VBA Boolean data types to store the results as either TRUE or FALSE.

This article is a guide to VBA Boolean Operator. Here, we learn how to use Boolean data type in Excel VBA, which gives the logical output, i.e., TRUE or FALSE, along with examples and downloadable templates. Below are some useful articles related to VBA: –