| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting / centring Text in a Msg Box
Hi
this should be very easy.... how do i get the text centred in a Msg Box? I can get text on separate lines through the '& Chr(10)' code, but if i split a long line of text & a short line of text onto separate lines it looks stupid because its all aligned left. as always, any help gratefully recieved. apologies for the rather basic question!!! cheers jb |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting / centring Text in a Msg Box
Hi JB,
There is no built in method. You could consder designing a custom userform. See also an old suggestion from Andy Pope: http://www.puremis.net/excel/Masters...ext_Andy.shtml --- Regards, Norman "JB2010" wrote in message ... Hi this should be very easy.... how do i get the text centred in a Msg Box? I can get text on separate lines through the '& Chr(10)' code, but if i split a long line of text & a short line of text onto separate lines it looks stupid because its all aligned left. as always, any help gratefully recieved. apologies for the rather basic question!!! cheers jb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Text in cells that already have text entered | Excel Worksheet Functions | |||
| copying text within a text box and losing formatting | Excel Discussion (Misc queries) | |||
| Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
| Shortcut for centring whatever is in a cell? | New Users to Excel | |||
Linear Mode
