I have a multipage userform (8 pages)that will have 12 questions on
each with a yes/no chkbox. Each chkbox is named yes1, yes2 etc.

When a user ticks yes, a value of 1 is added onto a hidden sheet named
"Chart".

Now the problem is once I close the workbook the previous ticks are
gone. I use me.hide and this works while the workbook is open.

How do I reference the previous state of the userform?

First post and just new to the excel experience.

Thanks

Allan