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

Материал из VB Эксперт
Перейти к: навигация, поиск

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>