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?

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?
.

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?
.