Hi Dave

I have a suspicion that dropping the linked cell will cause too much
re-coding, but if JLGWhiz comes up with something later it may help.

"Dave Peterson" wrote:

You may want to drop the linked cell. They can cause other trouble, too.

I think I'd just use code to update the cell (combobox1_change??).

Brettjg wrote:

I have some ActiveX controls on a sheet - they have macros attached to them,
and they have a unique linked cell each.

When I clearcontents the linked cell the control (a ComboBox) still shows
the last lot of data that was in there. The only way I can get rid of it is
to select a blank line, and then delete the zero that it produces (rather
cumbersome and inelegant). Is there a setting I can change? Or a line of code
I can inset into the clearing macro? Regards, Brett

--

Dave Peterson