MS Excel: CCUR Function (VBA)

In Microsoft Excel, the CCUR function converts a value to currency.

Syntax

The syntax for the CCUR function is:

CCur( expression )

expression is the value to convert to currency.

Applies To

• Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Function

• VBA function (VBA)

VBA Function Example

The CCUR function can only be used in VBA code. For example:

Dim LValue As Double
Dim LCurValue As Currency

LValue = 123.4567812
LCurValue = CCur(LValue)

In this example, the CCUR function would return the value 123.4568. The variable called LCurValue would now contain 123.4568.