Hi,

I have this userform in VBA Excel 2010, which has around 300 controls, most majority being checkboxes, the rest are option buttons, labels and textboxes; however, I need to save the status for each and all of them (value for checkboxes and option buttons, text and caption for textboxes and labels), so it can be recovered at a later time.

I thought to do this with a txt file with each line having a stat for one of the controls.

Question is, is there an easy way to go through all the controls, without checking them one by one? Or is there an better way to save them?

Thanks.