Data disappears from form after save and re-open | General Excel Questions & Answers

Data disappears from form after save and re-open

Paulette Brown

New Member

Members

Dashboards

Forum Posts: 2

Member Since:
December 9, 2016

Offline

May 20, 2017 - 4:05 am

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.

See Answer

SunnyKow

Malaysia

Member

Members

Dashboards

Forum Posts: 704

Member Since:
June 25, 2016

Offline

May 20, 2017 - 12:31 pm

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

Paulette Brown

New Member

Members

Dashboards

Forum Posts: 2

Member Since:
December 9, 2016

Offline

May 22, 2017 - 10:28 pm

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.

SunnyKow

Malaysia

Member

Members

Dashboards

Forum Posts: 704

Member Since:
June 25, 2016

Offline

May 23, 2017 - 9:12 am

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

SunnyKow

Malaysia

Member

Members

Dashboards

Forum Posts: 704

Member Since:
June 25, 2016

Offline

May 23, 2017 - 4:51 pm

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