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.