Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default "Store" ufm.checkbox values for later use

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




  #2   Report Post  
Posted to microsoft.public.excel.programming
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel displays "l" instead of "‚¬" symbol for Euro values lex63 Excel Discussion (Misc queries) 1 April 17th 09 10:10 AM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
How to create a scatter chart with 2 "X" values with common "Y"s M_LeDuc Charts and Charting in Excel 2 September 13th 07 10:26 PM
how to make a checkbox usable for users to "check" it? Brit Excel Discussion (Misc queries) 3 November 11th 06 08:24 PM
Changing "returned" values from "0" to "blank" LATATC Excel Worksheet Functions 2 October 20th 05 04:41 PM


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"