Message Box Sum Formatting

[Bill1234]

I have a message box pop up at the end of a macro I have, which gives the end user the sum of the re-formatted data.

The code works, but I am having trouble formatting the result as Currency...$100,000.00

The only thing I'm missing is the comma. I'm just trying to make it more visually friendly for the user.

Here's the code:

Please Login or Register  to view this content.

[mohan.r1980]

may be

Please Login or Register  to view this content.

[Bill1234]

Success. Thanks

[mohan.r1980]

Your welcome and thanks for rep