Hope all is well. I've been searching the internet all morning and haven't been able to find the solution to this. I basically have a userform that contains a handful of checkboxes, problem is that when a user closes the workbook the userform resets and all the checkbox values disappear. How do I set this up so that when you save/close the file and reopen it all the values are retained?
Thank you.
The values need to be stored in the workbook somewhere
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I guess my question is how do I go about doing that etc.
A bit hard to say without the workbook. The easiest way would be to store them on a hidden sheet, then get the userform to get the values on initialising
The following example will store all checkbox values as names, then restore when form is re-intialised.
Please Login or Register to view this content.
@wotadude,
Nice method.
I reduced it to:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks