VBA CCur function

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

CCur Function Description

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


The syntax for the CCur function in VBA is:

CCur( 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:

CCur 10 
'Result: 10

CCur 10.1 
'Result: 10.1

CCur "10.6" 
'Result: 10.6

Simply the best place to learn VBA!

Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match