Can I change the font size in MsgBox

[Gary Burton]

I am using MsgBox for promts, and the font is too small for what I want
to do; but I haven't been able to find a way to enlarge it short of changing
my screen resolution. Am I missing something that should be obvious?

 

[Jim Cone]

Gary,
The MsgBox font and font size come from a Windows setting.
In Windows XP...
You can get to it by right-clicking the desktop and choosing Properties.
Select the Appearance tab then the Advance button at the bottom right.
In the "Item" dropdown find Message Box and change the font/font size.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Gary Burton"
<[email protected]>
wrote in message
I am using MsgBox for promts, and the font is too small for what I want
to do; but I haven't been able to find a way to enlarge it short of changing
my screen resolution. Am I missing something that should be obvious?

 

[Gary Burton]

Thank you very much!!!

Either I'm no good with the help file, or it isn't in there.

 

[Nick Hodge]

Gary

Rather than using a built in MsgBox you could build a userform with a label
and commandbuttons. The labels here have much richer features, including
font size, colour, etc.

If you take care while setting it up and write some sub routines, calling it
many times, with different messages, caption, etc shouldn't be too much more
work than the built in one, but with much more flexibility

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Gary Burton]

I'm not sure what you mean when you say "userform". You may be talking
about what I call a "dialog box". My version of Excel (20002) does not
mention "userform" in the help file, but I have seen the word before. I
think it applies to later versions.

Anyway, I assumed that it was the same thing and opened one of my dialog
boxes. I couldn't find any way to change the font on either a lable or an
edit box. Could I change those with VBA? Let me know if I am missing
something that would be helpful.

Gary

Rather than using a built in MsgBox you could build a userform with a
label and commandbuttons. The labels here have much richer features,
including font size, colour, etc.

If you take care while setting it up and write some sub routines, calling
it many times, with different messages, caption, etc shouldn't be too much
more work than the built in one, but with much more flexibility

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Nick Hodge]

Gary

If you open the VBE (Alt+F11) you can then insert a user form (Insert>User
Form). On this you can design a form using controls from the toolbox and
one of these (The label) has the ability to alter the font properties

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

I'm not sure what you mean when you say "userform". You may be talking
about what I call a "dialog box". My version of Excel (20002) does not
mention "userform" in the help file, but I have seen the word before. I
think it applies to later versions.

Anyway, I assumed that it was the same thing and opened one of my
dialog boxes. I couldn't find any way to change the font on either a
lable or an edit box. Could I change those with VBA? Let me know if I am
missing something that would be helpful.

 

[Gary Burton]

Thanks!!

That looks like an even better solution.