Careful using End in code. End is dangerous as it clears all global
variables/objects. You would be better off with Exit Sub...
--
HTH...

Jim Thomlinson


"PCLIVE" wrote:

Here's one way.

Msg = "Your question?" ' Define message.
Style = vbYesNo ' Define buttons.
Title = "Title of message box" ' Define title.
If MsgBox(Msg, Style, Title) = vbNo Then End

MsgBox ("You selected Yes. Your code will continue")



"CarolineHedges"
<CarolineHedges.2c0rrr_1154701507.9944@excelforu m-nospam.com wrote in
message 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