| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RemoveItem - ComboBox
Hi!
I am trying to remove items from combo box (with 8 items), so I wrote this macro: For i = 0 To 8 Sheet1.ComboBox1.RemoveItem i Next and it breaeks down at 4! actually, it always removes only half of the items in combo box I tried it with 20, 100 .... and it doesn't matter! Does anybody have an idea how to make work it Thanks!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
RemoveItem - ComboBox
For i = 8 To 0 step - 1
Sheet1.ComboBox1.RemoveItem 1 Next 0 to 8 is 9 items. If there are actually only 8, then start at 7. -- Regards, Tom Ogilvy "Mike" wrote: Hi! I am trying to remove items from combo box (with 8 items), so I wrote this macro: For i = 0 To 8 Sheet1.ComboBox1.RemoveItem i Next and it breaeks down at 4! actually, it always removes only half of the items in combo box I tried it with 20, 100 .... and it doesn't matter! Does anybody have an idea how to make work it Thanks!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| Combobox options based on the input of another combobox | Excel Programming | |||
| use selected value from one combobox to populate another combobox | Excel Programming | |||
| ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
| How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Hybrid Mode
