msgbox data

M

Mike

Hello,
How can I add a cell contents into a msgbox string?

eg.
If cell = 1.4
I then want my msgbox to read (" You are 1.4 overspent!")

Thanks
Mike
 
S

SOS

NoSpaM,

Add the following line into your code:

MsgBox ("You are " & Range("A1").Value & " overspent!")

Regards

Seamu
 
B

Bob Phillips

Just a small point, but maybe better to use text so as to pick up the cell
style as well

MsgBox "You are " & Range("A1").Text & " overspent!"
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top