ActiveX controls still show data when empty
Yes that's right if you select the same thing it just sits there looking
dopey at you ( who in my particular case, is sitting there loking dopey at
it!). Brett
"JLGWhiz" wrote:
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
|