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)
or
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
Ivan
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.
