CCur VBA Function – How to Convert Data to Currency Type

1. CCur VBA Function – Description

The CCur VBA function   returns a value with the Currency data type  . It is a floating point number formatted as a currency ranging from -922,337,203,477.5808 to 922,337,203,685,477.5807 . The Currency data type is 8 bytes in memory. . Attempting to call a function with an argument outside the range -922,337,203,477.5808 to 922,337,203,685,477.5807 will generate an error. We will also get an error if we enter a value that contains characters other than numbers as an argument. In practice, the currency type is rarely used. As a rule, the usual Single or Double types are used to hold numbers that represent monetary amounts.

2. VBA CCur function – Syntax

CCur (Expression) As Currency

Expression : Any number from -922,337,203,477.5808 to 922,337,203,685,477.5807 stored in any data type (including String).

Function return : Currency / Number ranging from -922,337,203,477.5808 to 922,337,203,685,477.5807.

3. VBA CCur function – Example

How to use CCur function in VBA Excel? Below are examples of using the CCur function in the VisualBasic Editor.

Example 1 : Example of VBA CCur function – result in the MsgBox window.

Dim CurValue As Currency
CurValue = 12345.1234
MsgBox CCur (CurValue)

Example 2 : CCur VBA – Application example. The result in a sheet cell.

Dim CurValue As Currency
CurValue = 4567.1234
Range ("A1") = CCur (CurValue)
Excel VBA functions - CCur VBA function
Excel VBA functions – CCur VBA function

4. VB CCur function – Additional information

  • The function used for numbers outside the range -922,337,203,477.5808 to 922,337,203,685,477.5807 will return an error.

5. CCur VisualBasic function – Where to use?

The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016.

The article is part of the VBA Excel function list. You can find a list of all VBA functions at this address:  VBA functions .

Leave a comment

Your email address will not be published. Required fields are marked *

%d bloggers like this: