Changing the font size and color in a message box

[Bob Reynolds]

Is there a way to make the font bigger and change the color of the text in a
message box when it's displayed?
Thank you
Bob

 

[Dave Peterson]

Not in a msgbox.

But you could design your own userform and do as much formatting as you want.

 

[Bob Reynolds]

Thanks Dave,
I'll get some instructions on that later, I appreciate your help.
Bob

 

[Dave Peterson]

I'd start here:

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

 

[Gord Dibben]

Bob

Check out the ktMsgBoxAddin download from Colo's Junkroom.

Allows formatting of msgboxes, inputboxes etc.

http://puremis.net/excel/downloads.shtml


Gord Dibben MS Excel MVP

 

[Gord Dibben]

I should say, ktmsgboxaddin creates customizable forms that serve as msgboxes
AFAICT.


Gord