VB & VBA in a Nutshell: The Language

CCur Function

Named Arguments

No

Syntax

CCur(expression)

expression

Use: Required

Data Type: Numeric or String

A string or numeric expression that evaluates to a number between –922,337,203,685,477.5808 and 922,337,203,685,477.5807.

Return Value

expression converted to a currency data type.

Description

Converts an expression into a currency data type. The currency data type is stored in eight bytes, with a precision to four decimal places.

Rules at a Glance

• If the expression passed to the function is outside the range of the Currency data type, an overflow error occurs.

• Expressions containing more than four decimal places are rounded to four decimal places.

• The only localized information included in the value returned by CCur is the decimal symbol.

Example

If IsNumeric(sMyNumber) Then
    curMyNumber = CCur(sMyNumber)
End If

Programming Tips and Gotchas

• It's often tempting to use the Val function to return a numeric data type from a string. However, you should always use the correct data type function, which takes account of the computer's regional settings. In particular, CCur can successfully handle currency symbols and thousands separators embedded in a currency string, whereas Val can't. This means, for example, that if the user inputs a string value of $1,200.68, the CCur function can successfully convert it to a currency value of 1200.68, whereas Val returns a value of 0.

• CCur doesn't prepend or append a currency symbol; for this, you need to use the Format function or (in ...