Hi all:
I've created a UserForm with about 12 ListBoxes, all connected to various cells in my spreadsheet (the cells are named, and I've put the name of the cell in the "ControlSource" property for the appropriate ListBox). I'm able to open the form and select items in the ListBoxes, and it will change the values in the linked cells, no problem.
Here's the issue - after closing the form, some of the linked cells' values will blank out. It seems completely random - sometimes six of the cells will blank out, sometimes three will, sometimes only one. And it seems pretty random which ones do it.
Am I doing something wrong? I'd appreciate any suggestions - thanks.
I've created a UserForm with about 12 ListBoxes, all connected to various cells in my spreadsheet (the cells are named, and I've put the name of the cell in the "ControlSource" property for the appropriate ListBox). I'm able to open the form and select items in the ListBoxes, and it will change the values in the linked cells, no problem.
Here's the issue - after closing the form, some of the linked cells' values will blank out. It seems completely random - sometimes six of the cells will blank out, sometimes three will, sometimes only one. And it seems pretty random which ones do it.
Am I doing something wrong? I'd appreciate any suggestions - thanks.
