Outstanding, Tim. Thanks so much for your help -- your workbook made it all
so simple. Could you do something similar in Word?

st.
"Tim Zych" wrote in message
...
I am thinking about using a 12-digit array (there are 12 checkboxes) and
then "saving" that array somewhere on the ActiveDocument, but haven't
got
that totally worked out in my mind, yet.

That's exactly what the ControlSource does.

- Pick 12 cells that can store each of the 12 checkbox's "checked" values.
- In each of the checkbox's ControlSource property, type in those cell
references. For example, let's say that for you first checkbox, you want
to
store its "checked" state in Sheet1!A1, then in the ControlSource
property,
type that in.
Now the checkbox will be "linked" to that cell. Anytime you toggle the
checkbox, you will see that linked cell immediately reflect the True/False
value. The added benefit is that when you save the spreadsheet, the
spreadsheet values are saved too, so you never "reset" the checkbox state
like you are currently seeing.

I sent a sample workbook to you.

Hth,
Tim

"zsplash" wrote in message
...
Thanks for the help, guys.

Sorry, Tim, I simply do not understand the ControlSource property of
which
you speak. I assume it must be what Patrick means by "linking the boxes
to
a sheet", but the help files are not.
Hi, Patrick. Thanks for the input. I have already only hidden the ufm,
but
since the code ended (so that the user could input), when I start more
code,
the value of the checkboxes is back to nothing.

I am thinking about using a 12-digit array (there are 12 checkboxes) and
then "saving" that array somewhere on the ActiveDocument, but haven't
got
that totally worked out in my mind, yet.

st.

"Patrick Molloy" wrote in message
...
An alternative to linking the boxes to a sheet would be to HIDE the
userform
rather than unloading it. Negatives would be that when the form is
finally
closed- eg when th eworkbook is saved, the items are not saved.

--
Patrick Molloy
Microsoft Excel MVP