Thread: MsgBox commands
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Stone Frank Stone is offline
external usenet poster
 
Posts: 134
Default 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?
.