Look in Excel VBA help at the msgbox command. It pretty much explains the
options.

In a module, type msgbox, highlight it and hit F1


for information on events (sheet activate event for example) see Chip
Pearson's site on events

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"jdawg" wrote in message
oups.com...
I just have a quick question. I have a tab called MASTER and I want to
have a message box pop up whenever someone clicks on this MASTER tab
warning them "Changing these two dates, changes all dates in the
headers of the Excel Worksheet." I believe there is a message box that
shows a circle with an X in it and I think you use +vbCritical, but I'm
not positive. Any help would be greatly appreciated.