Message box if Yes continue with subroutine and if NO then exit sub and open sheet2

[KK1234]

Hi all,
I want to incorporate message box at the beginning of a long code.

Message box has 'YES' and 'NO'

If answer is yes then it should continue with further routine.

If answer is NO then :
1. It should get message box ' Go to sheet2'
when pressed OK then sub is exited
2. and sheet2 activates

This is repeated until the answer is YES.
Code

Please Login or Register  to view this content.

Any help please
Thanks

kind regards

[Norie]

You don't need the loop.

Please Login or Register  to view this content.

[KK1234]

Hi Norie,
Perfect solution.
Thanks for your prompt response and Kind help.
It goes to sheet2 verywell if answer is NO
However since messagebox routine is part of a big code, it still triggers the following which is the next action in the big code.
How to stop it please?

Please Login or Register  to view this content.

I have clicked* to thank you. I will close this as solved subsequently.
Kind regards

[Norie]

If you click No in the mesage box the sub Msgbox_Yes_No will be exited, that's what this line does.

Please Login or Register  to view this content.

If you want to totally stop code execution I would suggest putting the code for Msgbox_Yes_No inside the main sub.

[KK1234]

Hi Norie,
Thanks again.
It was a great help from you.
A learning curve for me.
Thanks again.
Kind regards