View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Zych[_2_] Tim Zych[_2_] is offline
external usenet poster
 
Posts: 41
Default "Store" ufm.checkbox values for later use

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