Learn Excel - Simplify Life with Excel Concepts

Excel CCur Function (VBA)

CCur Function VBA Code

How to use the CCur Function (VBA)

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


The Excel VBA CCur function converts an expression into a Currency data type.

For example,

  • The VBA Code CCur(10) would return 10
  • The VBA Code CCur(33.955555) would return 33.9556


To converts a value to a Currency.


The CCur function returns a Currency value.


CCur( expression )


The CCur function syntax has the following arguments:

  • expression: Required. The expression is that you want to convert to a Currency.
    • The "expression" can be any number between -922,337,203,685,477.5808 and 922,337,203,685,477.5807


  • The CCur function can only be used in VBA code in Microsoft Excel.
  • The Currency data type has a maximum of 15 digits to the left of the decimal place.
  • The Currency data type has a maximum of 4 digits to the right of the decimal place.
  • It can hold values between -922,337,203,685,477.5808 and 922,337,203,685,477.5807
  • An overflow error will occur if the value is out of range.
  • The Currency data type is a Value data type.
  • This function can be used to force currency arithmetic in cases where single precision, double precision or integer arithmetic would normally occur.
  • This function recognises decimals and thousand separators based on the local settings.

Useful Links: Link 1Link 2Link 3Link 4