Deleting all items from Combobox

[Jay]

Hello all,

I'm writing a function to remove items from a combobox, but I've run into a
problem that I can't seem to get around. Hoping someone can help me out.

Problem:
I have a combobox on an excel form. It contains the names of a specific
range of worksheets in the workbook. When a selection is made (combox is
changed), the combobox.value is the name of a worksheet. This value is used
to modify the data source of a chart.

The problem is, when I run the update function to update the worksheet list
for the comboboxes, I remove all the existing items, and then add the updated
worksheet list. This RemoveItem also runs the _Change function of the
combobox. This is where my problem is. I don't want _Change to run, I just
want all the values removed.

Any ideas are appreciated. If I've described that poorly, let me know and
I'll try again.

Thanks,
Jay

 

[Jay]

Not the most perfect solution, but I've found a way around it.

Instead of using cbo.RemoveItem and looping through each item, I used
cbo.Clear.

In the _Change event, I check if cbo.value = "". If it does = "", then do
nothing, otherwise, do the usual function call.

Jay