I plan to have a userform that will have 12 checkboxes that, when selected, it triggers an event where it will make visible a series of textboxes. For example:
Checkbox1 when true will trigger TextboxA, TextboxB, TextboxC to be visible. When False, Textboxes A-C will be invisible. Values entered in Textboxes are tied to a Control Source
Checkbox 2 when true will trigger TextBoxes D - F to be visible. When False, Textboxes D-F will be invisible.
Checkbox 3.......etc
My issue with checkboxes and userform is AFTER the userform is closed and reopened. A checkbox that is true when closed will appear false (uncheck) when its reopened. Where do I start writing code so that when the userform is initialized the checkboxes are the same when they last closed.
Since I plan to have more than 12 checkbox I was hoping someone can advise a variable when the form is initialized, rather than the strategy to write individual code for each checkbox at startup.
Thanks in advance.
Gal403
Bookmarks