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 : Boolean « Data Type « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type
  3. 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








Related examples in the same category

1.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.
2.Pass Boolean type variable to a function
3.Use if statement with boolean variable
4.Use True literal in If statement