Pass Boolean type variable to a function : Boolean « Data Type « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type
  3. Boolean

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








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.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
3.Use if statement with boolean variable
4.Use True literal in If statement