VBA CCur function

CCur Function Description

The VBA CCur function converts an expression (variable) to Currency data type.


The syntax for the CCur function in VBA is:

CCur( expression )


An expression / variable that is to be converted to Currency data type.

Example usage

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

CCur 10 
'Result: 10

CCur 10.1 
'Result: 10.1

CCur "10.6" 
'Result: 10.6