How can I scale up message boxes?

[DennisE]

Excel Experts,

I've developed my Excel userforms under my normal Windows
screen setting of 800 x 600 pixels. To accommodate users who
have set their screen settings to 1280 x 960 pixels, for example,
I multiply all form heights and form widths by 1.6 and set their
zoom factors to 160. Everything pretty much scales up just fine
when I do that, except for the MsgBox statements which appear
quite tiny and contain barely readable type. How can I similarly
scale up message box displays, and is there an alternative way
to approach the whole situation (other than to demand users to
manually lower screen settings to 800 x 600 and then restore
them afterwards)?

-- Dennis Eisen

 

[Jim Cone]

Dennis,

Here is my take on it is...
Most of the MsgBox properties are set by the operating system and
all MsgBoxes will appear small if the screen resolution is set high.

If the user has the screen resolution set that high he likes it.
So, don't try to fix what ain't broke.
(I personally think 600 x 800 is a bit on the low side)

I bet you've got some API functions tucked away someplace that
will change the MsgBox size and/or font. You can also add line
feeds before and after your text and add spaces to the start and
end of each line. That will force (within limits) the msgbox size to expand.
However, the font size will remain what windows says it is.

Regards,
Jim Cone
San Francisco, CA