Public Sub MboxTest()

Dim mbRes As VbMsgBoxResult

mbRes = MsgBox("Do you want to continue?", vbYesNo, "MsgBox Test")

If mbRes = vbNo Then
Exit Sub
Else
'your code here
End If

End Sub



"CarolineHedges"
<CarolineHedges.2c0rrr_1154701507.9944@excelforu m-nospam.com schreef in
bericht news:CarolineHedges.2c0rrr_1154701507.9944@excelfo rum-nospam.com...

At the beginning of the my macro I would like a message/prompt box to
appear with a question on it.

if the user ticks/presses yes then the marco continues, if the user
presses/clicks no then the macro stops.

Thanks in advance


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile:
http://www.excelforum.com/member.php...o&userid=35705
View this thread: http://www.excelforum.com/showthread...hreadid=568326