MsgBox Spacing of Characters

  • Thread starter Thread starter Chuckles123
  • Start date Start date
C

Chuckles123

This may be my imagination, but it appears there is not a one-to-one
relationship between the number of spaces that I insert between the
quote marks when specifying the Msg and the appearance of the text in
the MsgBox when the macro is executed. For example, I have some rather
long Msg statements that I would like to appear on three lines in the
MsgBox. So, I insert a guesstimated number of spaces into two sections
of the Msg spec to force word wrap at those sections. It's a trial and
error process. Is there a one-to-one relationship?

Thanks for a response.
Chuckles123
 
No.

msg = "Abcd" & vbNewLine & "Efgh" & vbNewLine & "ijkl

msgbox msg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top