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
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