Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combobox items determined by the selection in another combobox | Excel Programming | |||
how to add items to combobox | Excel Programming | |||
add a range of items to a combobox | Excel Programming | |||
ComboBox Items | Excel Programming | |||
ComboBox items | Excel Programming |