Hi Forum
I am trying to execute a code based on a yes no message box but struggling a bit as I have 3 parts to it.
If Yes is selected then I need to exit the sub, this bit is fine.
If no is selected and Cell B22 =0 again exit sub, this part is fine.
It is the third step i am struggling with:
If No is selected and Cell B22 =1 then execute the rest of the code.
Appreciate your help with this.
Please Login or Register to view this content.
Michelle1,
First, let me point out you have 2 exit sub scenarios where sheet7 would remain unprotected, screenupdating left off, and sheet1 remain visible... maybe that's on purpose, but uncommon so I wanted to point it out. As far as the simplest solution to your mentioned problem, you have an else too many in there... you don't need the second else nor if MSG1 = vbNo... try this:
I took the liberty of cleaning up a bit of the code in terms of layout.Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
HI Arkadi
Thankyou so much, works perfectly and thankyou for tidying the code.
Happy to help
Thanks for the rep!
If I could ask one thing? Please mark the thread as solved if you are satisfied with the solution? Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks