Avatar of ExpExchHelp
Flag for United States of America

asked on 

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


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,
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
[ fanpages ]

8/22/2022 - Mon