View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Clayman Clayman is offline
external usenet poster
 
Posts: 95
Default ComboBox.Clear method calling ComboBox_Change event?

I need to clear out a ComboBox in order to prep it for later use. At the
current time, it has 200 entries. Eventually it will have over 2000. Removing
each item individually is not a desirable option. It takes a while to load
it. I'd hate for it to take that long to unload.

Problem is, when I execute ComboBox.Clear, it appears to call the
ComboBox_Change() event. Since there is nothing in the ComboBox, it calls the
error handler that checks for unknown entries (ie: typing your own data in
the BomboBox).

Is there a way to execute the .Clear method without calling the _Change()
event?
--
Adios,
Clay Harryman