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

NoSpaM,

Add the following line into your code:

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

Regards

Seamu

--
Message posted from http://www.ExcelForum.com

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)

"SOS " wrote in message
...
NoSpaM,

Add the following line into your code:

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

Regards

Seamus


---
Message posted from http://www.ExcelForum.com/