VBA/Excel/Access/Word/Data Type/Boolean
Содержание
- 1 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
- 2 Pass Boolean type variable to a function
- 3 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.
- 4 Use if statement with boolean variable
- 5 Use True literal in If statement
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
<source lang="vb">
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
</source>
Pass Boolean type variable to a function
<source lang="vb">
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
</source>
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.
<source lang="vb">
Sub bool()
Dim myVal As Boolean myVal = True
End Sub
</source>
Use if statement with boolean variable
<source lang="vb">
Sub TestIfTrue()
Dim blnIsTrue As Boolean blnIsTrue = True If blnIsTrue = True Then MsgBox "True" End If
End Sub
</source>
Use True literal in If statement
<source lang="vb">
Sub TestIsTrue()
Dim blnIsTrue As Boolean blnIsTrue = 2 If blnIsTrue = True Then MsgBox "True" End If
End Sub
</source>