Hi patrick -- thanks for the response.

The workbook is made up of a variable amount of sheets that will be using
the UserForm, so probably not a viable solution unless I can make the linked
cells update depending on the ActiveSheet...

Having said that, I could link the controls to some hidden cells on the
ActiveSheet and Load directly from there, and then use a Concatenate function
to populate the visible cells.

hmmmm - it's all becoming clear.

Thanks for the 'nudge'

Regards

Trevor

"Patrick Molloy" wrote:

why don;t you link the check boxes to specific cells - maybe on a hidden sheet?

"Trevor Williams" wrote:

Hi All,

I have a UserForm that contains a multipage control. Each page of the
control contains several Frames, and each Frame contains several CheckBoxes.

Once the user has made their selection the Captions of the Checkboxes are
written to a specific Cell on the ActiveSheet, seperated with a semi-colon.

e.g. If the user has ticked CheckBox 1, 2, and 4 in Frame1 on Page1, and
then closed the form, the Cell A1 will contain the Value "Caption 1; Caption
2; Caption 4" (this is already in place and working.)

What I would like to do is re-load the UserForm based on the Cell Values.
When the form is re-opened the corresponding CheckBoxes will display as TRUE

Hope that makes sense(?) -- I'm using XL2002.

Look forward to your response.

Trevor Williams