Get rid of the = character. E.g.,

Msgbox "Hello " & Application.Username & ". " & Format(Date,"dd
mmm yyyy")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"rglasunow " wrote in
message ...
I tried what you both reccomended and thank you for the quick
reply.
However, I keep getting the following error when using both the
the
commands.

Compile Error:
Function call on the left-hand side of assignment must return
Variant
or Object.

then
MsgBox = is highlighted.

I just want an ok button to appear on in the message box not a
Yes, No,
Ok or Cancel command.

any sugestions?
Thanks!


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