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

Not in a msgbox.

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

Bob Reynolds wrote:
>
> 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

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

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Not in a msgbox.
>
> But you could design your own userform and do as much formatting as you
> want.
>
> Bob Reynolds wrote:
>>
>> 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

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...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

Bob Reynolds wrote:
>
> Thanks Dave,
> I'll get some instructions on that later, I appreciate your help.
> Bob
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Not in a msgbox.
> >
> > But you could design your own userform and do as much formatting as you
> > want.
> >
> > Bob Reynolds wrote:
> >>
> >> 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

--

Dave Peterson

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

On Sat, 5 Jul 2008 05:49:31 -0400, "Bob Reynolds" <(E-Mail Removed)>
wrote:

>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
>

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


Gord

On Sat, 05 Jul 2008 07:57:39 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:

>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
>
>On Sat, 5 Jul 2008 05:49:31 -0400, "Bob Reynolds" <(E-Mail Removed)>
>wrote:
>
>>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
>>