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.