Okay, guys. Help me think this through: With ufm1 (12 checkboxes), I
gather input about what forms to prepare, and then use that input to create
form fields on an Active Document.



After the user has input data into the form fields, I need to "remember"
what checkboxes they selected on ufm1, so that I can now work with the
selected forms. (Open the documents, add the formfield-input, print the
form, close the form, and open the next form.)



I think I have worked out everything but how to "remember" what checkboxes
were originally selected on ufm1. Can I somehow "store" ufm1.ckb1.value to
retrieve later? Is this completely a backward way of doing what I want to
do? If not, any suggestions about how I can "remember"??



TIA

Use the checkboxes ControlSource property. A1 or Sheet2!A1, etc.

Tim

"zsplash" wrote in message
...
Okay, guys. Help me think this through: With ufm1 (12 checkboxes), I
gather input about what forms to prepare, and then use that input to
create
form fields on an Active Document.



After the user has input data into the form fields, I need to "remember"
what checkboxes they selected on ufm1, so that I can now work with the
selected forms. (Open the documents, add the formfield-input, print the
form, close the form, and open the next form.)



I think I have worked out everything but how to "remember" what checkboxes
were originally selected on ufm1. Can I somehow "store" ufm1.ckb1.value
to
retrieve later? Is this completely a backward way of doing what I want to
do? If not, any suggestions about how I can "remember"??



TIA

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

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

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