I could not duplicate your problem, but I found that the combobox in the
test I set up did not respond to the click event code unless it was a
change. Don't know if this is standard or not. I will check it out later.


"Brettjg" wrote in message
...
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