MsgBox commands

J

JimPNicholls

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

Frank Kabel

Hi
AFAIK you can't center text in a messagebox. so you'll
have to create your own userform if you need this
 
F

Frank Stone

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