Message Box Functions in VB

[AndrewKent]

Hi there everyone,

This is probably a really easy one to answer...

I've been adding in message boxes to my macros to prompt a response from the user however some message boxes will contain a bit of text information before the initial prompt question, how do I get this to show on two separate lines and centred in the message box...

Dim Ans As Integer
    Ans = MsgBox("You are about to produce the Monthly Illness & Absence Report for Bancassurance Telephony." & vbCrLf & "Do you wish to continue?", vbYesNo)
    Select Case Ans
        Case vbYes '

Thanks in advance,

Andy

PS - if anyone knows of any decent tutorial websites that deal with the basics of VB that would help and stop me from asking daft questions

 

[Von Pookie]

Unfortunately, there is no built-in way to center the text on a msgbox. You can add spaces to move the text over to *appear* centered, though.

As for multiple lines: use a line feed. For example:

Msgbox "This is line 1." & vbCrLf & "This is line 2."

You could also use either Chr(10) or vbNewLine in place of vbCrLF. All three do the same thing

 

[Macropheliac]

Try it this way:

MsgBox "You are about to produce the Monthly Illness & Absence Report for Bancassurance Telephony." & Chr(13) & "Do you wish to continue?", vbYesNo

 

[AndrewKent]

Yeah after twenty minutes of playing around with it I figured out there was nothing I could about this apart from adding in spaces. Thanks for the workaround guys!