MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MsgBox Font

Posted by Mark Gravelle on November 11, 2001 2:04 PM

Is there a way to increase the MsgBox Font?

Also, I forget how to get the "stop" warning message box (or Object). Sorry, my terminology might not be accurate, I'm learning VBA one step at a time.

Posted by Luke on November 11, 2001 3:25 PM

The first question is interesting and I don't know. As to the second, it has to do with the button argument. See your helpfile 'msgbox'for the different types. For the critical, here the code.

value = msgbox("whatever",vbCritical)
value = msgbox("whatever",16)

Posted by Ivan F Moala on November 11, 2001 11:10 PM

Msgbox font size is controled via your systems
Display | Proerties | appearance

ie. Right click desktop
select properties
select appearance
select Item - messagebox


Posted by Kristy on November 12, 2001 11:30 AM

Mark, just in case you don't know, this will change your message box properties for the entire system, not just in Excel.