PDA

View Full Version : Font color in Msgbox



lcpx
10-23-2006, 05:00 AM
In MSExcel, is there a way I can specify the font color, size or background color in msgbox?

mvidas
10-23-2006, 06:57 AM
lcpx,

Unfortunately, no.

You could create your own userform that looks like a msgbox, and specify the font properties of the Label you're using to display the text. But using the default msgbox you're stuck with what's there.

Matt

lcpx
10-23-2006, 07:37 AM
Fair enough. Thanks very much

Zack Barresse
10-24-2006, 03:58 PM
There is an addin you can use to do this though, created by Masaru Kaji (aka Colo) called ktMsgBox and it can be found on his website. Look here (http://puremis.net/excel/downloads.shtml) under Utilities.

HTH