Deleting all items from Combobox
 

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

Deleting all items from Combobox
 

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

"Jay" wrote:

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