| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox commands
Excel 2k
Hi I have the following simple msgbox command. MsgBox "Updated spreadsheet!" & (Chr(13) & Chr(10)) & strName & ". Absent reason - " & strReason & " from " & JBStartDate & " to " & JBEndDate, vbOKOnly, Updated What I'm tring to do is centre the text within the msgbox. The default is left aligned. Can anyone help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MsgBox commands
Hi
AFAIK you can't center text in a messagebox. so you'll have to create your own userform if you need this -----Original Message----- Excel 2k Hi I have the following simple msgbox command. MsgBox "Updated spreadsheet!" & (Chr(13) & Chr(10)) & strName & ". Absent reason - " & strReason & " from " & JBStartDate & " to " & JBEndDate, vbOKOnly, Updated What I'm tring to do is centre the text within the msgbox. The default is left aligned. Can anyone help? . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MsgBox commands
I solved this problem by using leading spaces i.e.
"Update spreadsheet! to " Updated spreadsheet!" You may have to play with it to get it like you want but it works. -----Original Message----- Excel 2k Hi I have the following simple msgbox command. MsgBox "Updated spreadsheet!" & (Chr(13) & Chr(10)) & strName & ". Absent reason - " & strReason & " from " & JBStartDate & " to " & JBEndDate, vbOKOnly, Updated What I'm tring to do is centre the text within the msgbox. The default is left aligned. Can anyone help? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA commands | Excel Discussion (Misc queries) | |||
| IF commands | Excel Worksheet Functions | |||
| DOS commands | Excel Discussion (Misc queries) | |||
| Help with "if-then"/look up commands or what ever you think is best. | Excel Discussion (Misc queries) | |||
| MS DOS Commands | Excel Programming | |||
Linear Mode
