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.
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
Thanks Sunny, do you have any suggestions on how I can set up the form? Users need to be able to choose more than one item from each list.
Hi Paulette
You will have to create the buttons one by one on the worksheet (form) and link them to individual cells (preferably in another worksheet) so that the selections can be retained.
Sunny
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
