Yes/no msgbox -> if no is clicked, show userform with data still in it

Hi,

Been breaking my head over this one:
Got a sub that checks if 1 value is different from another value when you want to save the userform and write data to worksheets. If they are different, a msgbox is shown. When the user clicks yes, the sub writes another value and you can proceed. If the user clicks no, he should just go back to the useform, but with all data still visible (so don't clear the whole thing).

this is my code:

Please Login or Register  to view this content.

If I only use

Please Login or Register  to view this content.

, i get a message it's already open.
The problem with the code I'm currently using, is that when a user tries to save the userform multiple times, and clicks 'No' multiple times, the userform opens 'X' amount of times (4x clicked 'No' - 4 userforms show behind eachother. So when i press cancel on the userform, I need to cancel 'X' times.

Anyone know a decent way of just 'unloading the messagebox and return to the filled in userform?


Thank you!

Have you tried Else Nothing? I mean:

Please Login or Register  to view this content.

Try..

Please Login or Register  to view this content.

ave you tried

Please Login or Register  to view this content.

???
Can you upload a sample?

Thank you for the rep pclaesen. Glad I could help.

pclaesen,
Sorry about that, I made a mistake on that line. I know you already have the issue resolved, but I'll provide you with the corrected code for reference..

Please Login or Register  to view this content.