ExpExchHelp
asked on
Excel message box (pop-up upon opening) does not show sales value in proper currency format
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're very welcome :)
ASKER