Round 2 decimal places

[Ventoux]

Hi, I just started practising VBA and have the following code

Please Login or Register  to view this content.

Pressing F5 results in curCommission giving me a Dollar value with four decimal places, which I would like to reduce to just two. I googled severel techniques, but non seemed to quite work.
Why, for example, is putting

Please Login or Register  to view this content.

not doing the trick, but showing an error? Also, pressing F1 I see that dim As Currency should be 2 decimal places, why though are there in fact 4 decimal places in my case?


Thank you.

[6StringJazzer]

Currency is a fixed-point number with four digits to the right of the decimal.

Round is a function, not a statement. It returns a value. If you use the statement you provided above it will have no effect. You have to do something like this, to replace your second-from-last line of code:

Please Login or Register  to view this content.

[Ventoux]

great, thank you!