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