Excel VBA CDec Function
VBA CDec Function: The CDec function in VBA converts an expression into a Decimal data type.
Syntax
CDec (Expression)
Parameter
Expression (required) – This parameter represents the expression that you want to convert to a Decimal.
Return
This function returns a decimal figure after converting the specified expression into a decimal data type.
Example 1
Sub CDecFunction_Example1() ' Converting the string and numeric values into Decimals Dim dec As Variant dec = CDec("59001.090876") ' The variable dec will return the Decimal 59001.09088 Cells(1, 1).Value = dec End Sub
Output
59001.09088
Example 2
Sub CDecFunction_Example2() ' Converting the string and numeric values into Decimals Dim dec As Variant dec = CDec(19 / 87) ' The variable dec will return the Decimal 0.218390805 Cells(1, 1).Value = dec End Sub
Output
0.218390805
Example 3
Sub CDecFunction_Example3() ' Converting the string and numeric values into Decimals Dim dec As Variant 'passing only string values dec = CDec("Hello VBA") ' The variable dec will return a run-time error Cells(1, 1).Value = dec End Sub
Output