VBA CDec function

CDec Function Description

The VBA CDec function converts an expression (variable) to decimal value.


The syntax for the CDec function in VBA is:

CDec( expression )


An expression / variable that is to be converted to decimal value.

Other Notes

If the expression / variable can’t be converted to a decimal, the function with return Error code 13: Type mismatch.

Example usage

The CDec function can be used in VBA code. Let’s look at some VBA CDec function examples:

CDec 10
'Result: 10

CDec 10.6
'Result: 10.6

CDec "20"
'Result: 20

CDec 10.12345678901234
'Result: 10.1234567890123