How to stop code,look at a sheet, then continue the code

I am running code which queries some data and then gets this into a form that can be used by a dashboard. A little after the code has started I stop it with a msgbox with a Yes/No answer to the question "Do you need to add new NominalCodes?"
If the answer is No the code continues if Yes then I want to open a specific worksheet make manual changes then click a button on the sheet to indicate that the changes are made and then to continue the code.
My attempts, as can be seen in the attachment have been unsuccessful, and I need help.
John

dflak,
Many thanks for you interest in my problem. First I tried your code as it is with the addition of the flag sheet. Without success I am sorry to say. Then I thought that I had got two ways of flagging the need to leave sheet "AdjustedCC" and carry on with the code. Your "ContiueFlag" and my ButtoneClick which turns from FALSE to TRUE when the button on sheet"AdjustedCC is pressed and back to False again when the code finishes. So I tried modifying the code to use the button still with no success. In one way the code works by branching in the way I want but it does not stop when "AdjustedCC" is activated it just carries on to the end.
I have called the edited copy Trial34. It has in it Sub NewYear 2 for the new code. I am attaching this in the hope that you may have patience and the time to look at it again.
John

I sent a part of the project because the whole thing exceeds the forum limit. I have now found a simple work round by giving the check for new nominal codes its own button, then the button on the sheet AdjustedCC sends you back to userForm1.
Thanks very much for your help though.
John