display a 2 row message pop -up vba 6

2019-07-04 01:34发布

is there a way to display a 2 or 3 or 4 or n line message on a pop-up window in vba 6 ?

For the moment my pop-up window ( calling the MsgBox function) displays the message like this :

       You did something wrong. Please enter valid input.

and I want it to display the message like this

      You did something wrong. 
     Please enter valid input.

can you please provide a code sample?

many thx in advance, radu

2条回答
仙女界的扛把子
2楼-- · 2019-07-04 02:13

Relatively easy request

    iResult = MsgBox("This information is on the first line. " & vbCrLf & "This information is on the 2nd line. " &vbCrLf & _
        "Do you wish to continue?", vbYesNo + vbInformation, "Message Box")
查看更多
SAY GOODBYE
3楼-- · 2019-07-04 02:19

Just add a newline in your message:

MsgBox "Text 1" & vbNewLine & "text 2.
查看更多
登录 后发表回答