View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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!!!