New Member
December 9, 2016
I created a form which uses tables from a hidden sheet.
When the form is filled out, saved, and re-opened, the data disappears. Does anyone have any ideas how to solve this so that the form can be saved and sent electronically? Thank you.
VIP
Trusted Members
June 25, 2016
Hi Paulette
To retain the selection, link the check box, radio buttons, list box etc to a cell.
Unfortunately your are using multi-select for the list box and that cannot be linked to a cell.
If you need to have multiple selections, you have to create each check box one by one and link each to a different cell.
I know it is a real pain, but that is the only way.
Sunny
Answers Post
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
Probably you can use this as an example. It doesn't use check boxes but actual cells for the tick.
Just double click on the gray cell to toggle the tick (need to enable macro).
For the countries you can consider using a data validation
Can't help you on your date picker as I don't have it.
Hope this helps.
Sunny
1 Guest(s)