How to use the CDec Function (VBA)

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

SUMMARY:

The Excel VBA CDec function converts an expression into a Decimal value.

For example,

• The VBA Code CDec("2.00000001") would return 2.00000001
• The VBA Code CDec(2.00001 *2.00001) would return 4.0000400001

PURPOSE:

To converts a value to decimal number.

RETURN VALUE:

The CDec function returns a Decimal value.

REMARKS:

• The CDec function can only be used in VBA code in Microsoft Excel.
• The Decimal data type is a sub type of the Variant data type.
• The CDec function always returns a variant whose value has been converted to a Decimal subtype.
• An overflow error will occur if the value is out of range.
• There does not actually exist a Decimal data type although it is possible to have a Variant data type, whose subtype is Decimal.

CDec Function VBA Code example:

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

CDec Function Example (as VBA code)

The CDec function can only be used in VBA code in Microsoft Excel.
The following VBA code shows how the CDec function can convert values into Decimal number.

Dim TestCase1 As String
Dim TestCase2 As Variant
TestCase1 = "89999999999.2 * 9.01"
TestCase2 = CDec(TestCase1)

In the above example, CDec(TestCase1) would return the decimal value 810899999992.792 , the variable called TestCase2 would now contain the value 810899999992.792

VBA CDec Function Error:

If the Expression that is supplied to the CDec function cannot be converted into a numeric value, you will get the error:
Run-time error '13': Type mismatch

---

---

Download Example Sample Excel File

CDec-function-example.xlsm

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