Yes No MsgBox 1

[jt643]

Is there any way to code logic to respond to whether the user clicks 'yes' or 'no' on a yes/no MsgBox?

I want the box to disappear and nothing further run in the code if the user clicks 'no'. If they click 'yes', then the code will continue to run.

Thanks.

 

[RoyVidar]

Something like this:

[tt]if msgbox("Wanna continue?",vbyesno+vbquestion)=vbno then
exit sub
end if[/tt]

or

[tt]if msgbox("Wanna continue?",vbyesno+vbquestion)=vbyes then
' perform some code
end if[/tt]

Roy-Vidar

 

[jt643]

Incredible! Thanks Roy-Vidar.