Save Multiple Checkbox Values

[cluelessdood]

Hello, everyone! I'm having some trouble (again) with my code. After closing the UserForm and reopening it, I'd like for it to show the checkboxes that were previously checked for the ActiveCell. Currently, it does return the value of the last checkbox, but not the rest. I was hoping you awesome folks could help. Thanks.

Please Login or Register  to view this content.

[dominicb]

Good morning cluelessdood

Userforms won't "remember" data from previous sessions - you can set a default value through VBA for every time they're opened but that's about it.

What you will need to do is set up a hidden sheet that will store the default values. When the userform is opened, these values are read from your hidden sheet and the userform is populated using these values.
When the userform is closed, these values are saved back to your hidden sheet.
These are then saved with the file for the next time the userform is opened.

HTH

DominicB

[cluelessdood]

Good morning cluelessdood

Userforms won't "remember" data from previous sessions - you can set a default value through VBA for every time they're opened but that's about it.

What you will need to do is set up a hidden sheet that will store the default values. When the userform is opened, these values are read from your hidden sheet and the userform is populated using these values.
When the userform is closed, these values are saved back to your hidden sheet.
These are then saved with the file for the next time the userform is opened.

HTH

DominicB

I made the hidden sheet, but I'm not really sure how to connect it...

[dominicb]

Hi cluelessdood

If your hidden sheet is called "Sheet1", in cell A1 type "FALSE" - you don't have to type in uppercase, the cell will recognise it as a Boolean value and do it for you.
In your UserForm_Initialize module use a line like this for every checkbox :

Please Login or Register  to view this content.

To set the flags in this sheet on exit, just use this command in reverse, thus :

Please Login or Register  to view this content.

HTH

DominicB