VBA MsgBox Problems

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.
 
B

Bob Phillips

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)
 
H

Harald Staff

--
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
 
Top