Odd behaviour from MsgBox

**FredBloggs** · 07-09-2007, 06:04 AM

Hi, I'm a complete noob so my apologies if the answer is obvious, but could someone tell me why this works:

    Answer = MsgBox("Do you want to continue ? ", _
        vbOKCancel)
    If Answer = vbCancel Then Exit Sub

and this doesn't:

If MsgBox("Do you really want to list all deal types here? Warning: the list will _
overwrite any data in the cells below and CANNOT BE UNDONE!", vbQuestion + vbYesNo) _
= vbNo Then Exit Sub

The problem seems to lie in what I'm trying to get the MsgBox to say. Does it not like more than one of the odd ?!@/ etc characters per box?

Thanks in advance for any help.

**Simon Lloyd** · 07-09-2007, 07:41 AM

This worked fine for me:

If MsgBox("Do you really want to list all deal types here?" & Chr(13) & _
"Warning: the list will overwrite any data in the cells below and CANNOT BE UNDONE!", vbQuestion + vbYesNo) _
= vbNo Then Exit Sub