Number format in a message

L

Lianna

I have a message box that shows a message and a value from
a worksheet. How do I define the number format of the
value in the message box?

I'm using Excel 2000.

Thanks,
Lianna
 
T

Tom Ogilvy

If you want to display what is displayed in the cell rather than the
underlying value

msgbox Range("a1").Text

rather than
msgbox Range("A1").Value

Regards,
Tom Ogilvy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paragraph numbering in Word 1
Excel does not accept text format! 0
Messages showing in "Find related" but not in Conversation view 0
Can't send emails but can receive in Outlook 2019 1
Line Numbers Will Not Show 0
Inconsistent formatting of section numbers 0
VBA - exporting serial letters to single documents 0
"The object was saved in an invalid format and cannot be read." 0

Top