WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Learn VBA » VBA Boolean

VBA Boolean

Excel VBA Boolean Operator

Boolean is a data type and it is also an inbuilt 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 which is used for logical comparison, the declaration of this data type is similar to all the other data types.

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

VBA Boolean

Working with Boolean Data Type in VBA Programming Language

Now let’s see the example of setting Boolean Operator values to variables using the VBA Code.

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

Follow the below steps to have a fair bit of knowledge on 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 test 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 VBA.

Code:

Sub Boolean_Example1()

  Dim MyResult As Boolean

  MyResult = 25 > 20

  MsgBox MyResult

End Sub

VBA Boolean Example 1-3

Now run the excel macro through the F5 key or manually and see the result.

Popular Course in this category
Sale
VBA Training (3 Courses, 12+ Projects)
4.6 (247 ratings)
3 Courses | 12 Hands-on Projects | 43+ Hours | Full Lifetime Access | Certificate of Completion
View Course

VBA Boolean Example 1-4

Ok, 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.

This is the basic structure of VBA Boolean Datatypes.

Boolean Data Type Cannot Hold Other than TRUE or FALSE.

VBA Boolean is a logical data type; it holds TURE 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, I have declared the variable “BooleanResult” as Boolean.

 Dim BooleanResult As Boolean

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

BooleanResult = "Hello"

I have declared the variable as Boolean, but I have assigned the value as “Hello,” which is other than logical values i.e., either TRUE or FALSE.

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

VBA Boolean Example 2-1

All the Numbers are TRUE, and Zero is FALSE

As I told, TRUE is represented by 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

I have assigned the value to the variable as 1, and this will show the result as TRUE.

VBA Boolean Example 3-1

Now, look at the below code.

Code:

Sub Boolean_Example3()

    Dim BooleanResult As Boolean

    BooleanResult = 0

    MsgBox BooleanResult

End Sub

VBABoolean Example 3-2

In this code, I have assigned the value to the variable as 0, and this will show the result as FALSE.

VBA Boolean Example 3-3

Not only 1 or 0 we, but any number assigned to the variable except zero is also treated as TRUE, and only zero will be treated 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 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.

Recommended Articles

This has been 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 & downloadable templates. Below are some useful articles related to VBA –

  • VBA End Function
  • Use IF OR Function in VBA
  • IFERROR Function in VBA
  • Do Until Loop in VBA
7 Shares
Share
Tweet
Share
VBA Training (3 Courses, 12+ Projects)
  • 3 Courses
  • 12 Hands-on Projects
  • 43+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download VBA Boolean Data Type Excel Template

New Year Offer - VBA Training Course (6 courses, 35+ hours video) View More