VBA MsgBox Problems

  • Thread starter Thread starter Mark1
  • Start date Start date
M

Mark1

I've made a message box that displays the value of a
cell. The cell is currency format, but when it comes up
on the message box, the number is not formatted as
currency. I've tried everything I know to do and it won't
work. Help is appreciated.
 
msgbox Format(Range("A1"),"£ #,##0.00")

as an example

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
--
HTH. Best wishes Harald
Followup to newsgroup only please.

Mark1 said:
I've made a message box that displays the value of a
cell.
Click to expand...

In this case don't. Display the Text of the cell:
MsgBox Range("A1").Text

....so what's the catch ? It will display ##### if the column is too narrow.

HTH. Best wishes Harald
 
Back
Top