I have an application that has been in use for many months, but today a new
problem began occurring. The workbook has numerous combo boxes, checkboxes,
and option buttons linked to cells beneath them with the linkcell property.
When I select the value, it fills in the cell just fine. However, when I
clear the cell value, the associated object value no longer clears. I use a
"Clear All" button with a macro that deletes the cell values to clear all the
selections at once, but it no longer works. It also doesn't work to just
delete the cell values manually. If I go into Properties, delete the
linkcell value, and then reenter it, the selection clears, but if I reselect
another value the problem returns. I reloaded the workbook from a backup
from a week ago, but that didn't help either. Any suggestions?