Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ComboBox_Change Event to Populate another Combox | Excel Programming | |||
Calling a sub method | Excel Programming | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
Combobox_change event problem | Excel Programming | |||
Combobox.clear | Excel Programming |