Hi all,

Is it at all possible to change the colour of a message box or font in
it? if it is can you point me in the right direction?

I know there are add ins but my company network will not allow these.

Thanks

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=478524

Hi Simon,

Is it at all possible to change the colour of a message box or font in
it?

This is not natively possible in Excel.

Consider, instead, designing a userform as your message box. This will
afford you a wide range of formatting options.

If you are not familiar with userforms, see Debra Dalgleish's introductory
tutorial at;

http://www.contextures.com/xlUserForm01.html


---
Regards,
Norman



"Simon Lloyd"
wrote in message
...

Hi all,

Is it at all possible to change the colour of a message box or font in
it? if it is can you point me in the right direction?

I know there are add ins but my company network will not allow these.

Thanks

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=478524

As far as I know, you can't change the color or any of the attributes of
the MsgBox. If you desire to have an ornate message box, use a
customized Userform
and decorate it with your bells and whistles.

David


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=478524