CBool Function
Converts an expression or a set of expressions into a boolean. An expression is composed of strings, numbers and operators. Comparison, logical or mathematical operators are allowed inside expressions.
Syntax:
CBool (expression As Variant) As Boolean
expression can be a number or a set of combined expressions.
Return value:
Boolean
Parameters:
expression: A logical expression, a mathematical formula, a numeric expression or a set of expressions combined with operators. During expression evaluation logical operators take preceedence over comparison operators, which in turn take preceedence over mathematical operators.
The expression can be a number or mathematical formula. When equals to 0, False is returned, otherwise True is returned.
Multiple expressions such as expr1 [[{operator] expr2]..] can be combined. expr1 and expr2 can be any string or numeric expressions that you want to evaluate. CBool combines the expressions and returns either True or False. operator can be a mathematical operator, logical operator or comparison operator.
Error codes:
5 Invalid procedure call
Example:
In the following examples, the CBool function evaluates a logical expression, a mathematical formula and the value that is returned by the Instr function. The function checks if the character "a" is found in the sentence that was entered by the user.
Sub ExampleCBool
Print CBool( 1>2 Xor 44 ) ' computes to True
Print CBool( expression := 15 /2 -7.5 ) ' displays False as expression equals 0
txt = InputBox("Please enter a short sentence:")
' Proof if the character "a" appears in the sentence.
' Instead of the command line
' If Instr(Input, "a")<>0 Then...
' the CBool function is applied as follows:
If CBool(Instr(txt, "a")) Then
MsgBox "The character »a« appears in the sentence you entered!"
EndIf
End Sub