troubleshooting Question

Excel message box (pop-up upon opening) does not show sales value in proper currency format

Avatar of ExpExchHelp
ExpExchHelpFlag for United States of America asked on
VBAMicrosoft ExcelMicrosoft Office
3 Comments1 Solution76 ViewsLast Modified:
Experts:

Upon opening an Excel workbook, I would like to show (via popup message) current sales values.

For example, to display the sales amount for Q1, I use the following VBA.
MsgBox "Sales for Q1 is: " & Worksheets("Sheet1").Range("B1")

In the XLS/tab, the value is in the following format: $3,212.04.  However, the msgbox shows "3212.038".    

My question:  How can I modify the format of the msgbox  to include the proper currency (rounded) format?   Please see attached XLS for details.

Thank you,
EEH
ASKER CERTIFIED SOLUTION
[ fanpages ]

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros