Yes/No Message box keeps looping

Another method:

Please Login or Register  to view this content.

The problem is that without specifying what the target is, in your code whenever the sheet changes and B2 still = 1 then the code just fires again.

The above code will fire only when the sheet change happens to B2. Not ideal in all instances, and we certainly don't have enough info about your workbook in order to say if this approach would be suitable or not, but adding it for the sake of info.

BSB

Hi guys,
Thanks for the quick replies. The coding worked to hide and clear the sheets but won't work to expand it again.

I apologise for being vague I was hoping with a little nudge in the right direction it might jog my memory and I could figure out the rest. So, within this sheet the users can enter any number between 0 and 20, if they enter 0 or it is blank then everything is shown, if they enter more than 20 an error will show up to advise that they can only enter a value up to 20. Lastly, depending on what value they enter between 1 and 20 will cause the sheet to hide/unhide certain columns and clear the data in any columns that are due to be hidden.

It works for me. Enter 1 in B2 and columns are hidden, change it to 0 and they're unhidden.

Doesn't do anything if you enter 2, 3, 4 etc. as the snippet of code provided only deals with 0 or 1.

BSB

Hi,

I've come out of the workbook and gone back in and it is now working correctly, not sure what was wrong but, thank you both so much for the help.

Happy to help. Glad it's sorted

BSB