VBA/Excel/Access/Word/Data Type/Boolean

A Boolean variable can be set only to True or False. You can use the keywords True and False to set the value of a Boolean variable

 
Sub bool()
    Dim b As Boolean
    b = True
    If b = True Then
        MsgBox "The product is available."
    Else             "b = False
        MsgBox "The product is not available."
    End If
End Sub

Pass Boolean type variable to a function

 
Function MakeIceCream(VanillaToBeAdded As Boolean) As String
    If VanillaToBeAdded Then
        MakeIceCream = "Vanilla"
    Else
        MakeIceCream = "No Vanilla"
    End If
End Function
Sub Hungry()
    Debug.Print MakeIceCream(True)
End Sub

The Boolean data type accepts one of two values, True or False. You may also assign the value 1 (True) or 0 (False) to a Boolean variable.

 
Sub bool()
    Dim myVal As Boolean
    myVal = True
End Sub

Use if statement with boolean variable

 

Sub TestIfTrue()
    Dim blnIsTrue As Boolean
    blnIsTrue = True
    If blnIsTrue = True Then
        MsgBox "True"
    End If
End Sub

Use True literal in If statement

 
Sub TestIsTrue()
    Dim blnIsTrue As Boolean
    blnIsTrue = 2
    If blnIsTrue = True Then
        MsgBox "True"
    End If
End Sub