How to use the CDbl Function (VBA)

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

SUMMARY:

The Excel VBA CDbl function converts an expression into a Double data type.

For example,

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

PURPOSE:

To converts a value to double data type or double precision floating point numbers.

RETURN VALUE:

The CDbl function returns a Double value.

REMARKS:

• The CDbl function can only be used in VBA code in Microsoft Excel.
• The Double data type is a Value data type.
• This function uses the locale setting to identify the different decimal separators and thousand separators.
• The CDbl function is used to convert an expression to a Double.

CDbl Function VBA Code example:

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

CDbl Function Example (as VBA code)

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

Dim TestCase1 As String
Dim TestCase2 As Double
TestCase1 = "89999999999.2 * 9.01"
TestCase2 = CDbl(TestCase1)

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

VBA CDbl Function Error:

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

---

---

Download Example Sample Excel File

CDbl-function-example.xlsm

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