How to use the CVar Function (VBA)

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

SUMMARY:

The Excel VBA CVar function converts an expression into a Variant data type.

For example,

• The VBA Code CVar("Hello") would return "Hello"
• The VBA Code CVar(33.955555) would return 33.955555

PURPOSE:

To converts a value to a Variant.

RETURN VALUE:

The CVar function returns a Variant value.

REMARKS:

• The CVar function can only be used in VBA code in Microsoft Excel.
• The CVar Function can convert different types of expression (Integer, Boolean and Date) into String data types.
• The CVar function can be used to convert numeric values, strings and dates into Variant data types.
• The Variant data type can hold numeric, string, or date values.
• VBAs hexadecimal notation symbol is "&H"

CVar Function VBA Code example:

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

CVar Function Example (as VBA code)

The CVar function can only be used in VBA code in Microsoft Excel.
The following VBA code shows how the CVar function can convert values into Variant data types.

Dim TestCase As Single
TestCase = CVar(253) & " Cap"

In the above example, CVar(253) & " Cap" would return the Variant value "253 Cap", the variable called TestCase would now contain the Variant Data Type value "253 Cap"

VBA CVar Function Error:

If you supply the CVar function with input value which is outside the range of the data type being converted to, you will get the error:
Run-time error '6': Overflow

---

---

Download Example Sample Excel File

CVar-function-example.xlsm

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