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/