How to use the CBool Function (VBA)

This Excel tutorial explains how to use the Excel CBool function with syntax and examples using VBA.

SUMMARY:

The Excel VBA CBool function evaluates an expression, and returns the result as a Boolean data type.

For example,

• The VBA Code CBool(1=2) would return False.
• The VBA Code CBool(1=1) would return True.

PURPOSE:

To convert an expression to a Boolean result.

RETURN VALUE:

Boolean (True or False).

REMARKS:

• The CBool function can only be used in VBA code in Microsoft Excel.
• If the expression evaluates to a nonzero value, CBool returns True, otherwise, it returns False.
• This function will convert any numerical value into a boolean value.
• If the expression passed to the function is outside the range of the data type being converted to, an error occurs.
• Numeric non-zero values are converted to True.
• The strings "True" and "False" are converted to True and False respectively.

CBool Function VBA Code example:

Diffrent way to use the CBool function using Excel VBA Code...

CBool Function Example (as VBA code)

The CBool function can only be used in VBA code in Microsoft Excel.
The following VBA code shows how the CBool function can return the result of a logical expression.

Dim TestCase As Boolean
TestCase = CBool(1=2)

In the above example, CBool(1=2) would return false, the variable called TestCase would now contain the value false.

VBA CBool Function Error:

If you supply the CBool functi on with a String Expression, that cannot be converted to a number, you will get the error:
Run-time error '13': Type mismatch

---

---

Download Example Sample Excel File

CBool-function-example.xlsm

Useful Links: Link 1… Link 2… Link 3… Link 4…