Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Centering MsgBox text
Is there a way to center the prompt text in a MsgBox?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Centering MsgBox text
Hi Patrick,
Patrick wrote: Is there a way to center the prompt text in a MsgBox? No, not really. You could use the Space$ function to pad the beginning of the string with spaces, but that would require some trial and error to find the correct length. Plus, if a user has a different standard font than you, it may not appear as expected on his/her machine. The best way would be to create your own UserForm that looks/acts like a MsgBox. You could drop a label control on it and center the text that way. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Centering MsgBox text
Thanks Jake, that makes perfect sense!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Centering text in right-side header block | Excel Discussion (Misc queries) | |||
Cell Text Alignment - Not A Centering Issue | Excel Discussion (Misc queries) | |||
Centering the text in a message box | Excel Programming | |||
Centering the text in a message box | Excel Programming | |||
VBA MsgBox() Text | Excel Programming |