VBA CCur function

CCur Function Description

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

  • VBA Reference – Conversion functions

    • Syntax

    The syntax for the CCur function in VBA is:

    1
    CCur( expression )

    Parameters

    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:

    1
    2
    3
    4
    5
    6
    7
    8
    CCur 10
    'Result: 10
     
    CCur 10.1
    'Result: 10.1
     
    CCur "10.6"
    'Result: 10.6