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