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/