Centering MsgBox Message

  • Thread starter Thread starter Syd
  • Start date Start date
S

Syd

I have a pop up message box with two lines of text to
alert the user. The message looks like this: "Thank You" &
vbCrLf & vbCrLf & "You Just Canceled The Current Year's
Data Change."

What I'd like to do is center each of those message
statements on the pop-up message box. Similar to:
"Thank You"
"You Just Canceled The Current Year's Data Change."


How can I accomplish this?

Thanks,
 
Try putting about 30 spaces in front of "Thank You"

MsgBox " Thank You" & vbCrLf & vbCrLf & "You
Just Canceled The Current Year's Data Change."
 
or, use Tabs (vbTab & " ... ")
either way, it is a pain to do it since proportional fonts make spaces
(Tab = 8 spaces ??) smaller than letters.

Might be easier to make your own form for this !
Then you can use centered property of text box.
-=-=
 
Back
Top