Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to center text in a msgbox
I have got a message box which I want two lines of text on. I am using chr(13) for the carrage return, but would like to centre the text in the message box. Can thie be done??? Cheers, Dave -- Dave_2k5 ------------------------------------------------------------------------ Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667 View this thread: http://www.excelforum.com/showthread...hreadid=390136 |
#2
|
|||
|
|||
Can thie be done???
Probably not. I suppose you could pad with spaces but I don't think that would necessarily look the same on all machines. When you want to get fancier than a Msgbox go with a userform. It's quite easy to do one that just displays a message and an OK button. -- Jim "Dave_2k5" wrote in message ... | | I have got a message box which I want two lines of text on. | | I am using chr(13) for the carrage return, but would like to centre the | text in the message box. | | Can thie be done??? | | Cheers, | | Dave | | | -- | Dave_2k5 | ------------------------------------------------------------------------ | Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667 | View this thread: http://www.excelforum.com/showthread...hreadid=390136 | |
#3
|
|||
|
|||
Would a few spaces at the start of each line suffice? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=390136 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut for wrap text or vertical center in cell | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
center text in a formula result | Excel Worksheet Functions | |||
shortcut to center text other than format toolbar? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |