"Store" ufm.checkbox values for later use

  • Thread starter Thread starter zsplash
  • Start date Start date
Z

zsplash

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.
 
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 said:
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.
 
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 said:
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
 
Back
Top