Results 1 to 2 of 2
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    RemoveItem ComboBox (VBA/Excel/2003)

    I have a ComboxBox that is filled with items. I need to re-initialize it and fill with items from a different part of the list.

    Is there an easy way to ZAP / remove / delete <img src=/S/electric.gif border=0 alt=electric width=15 height=15> the items in the list? I am going nuts trying to figure this one out. <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>
    Alan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: RemoveItem ComboBox (VBA/Excel/2003)

    A combo box on a userform has a Clear method that reinitializes (clears) the entire list:

    Me.ComboBox1.Clear

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •