Remove Item in a combobox

**aman1234** · 02-23-2009, 05:36 PM

Hi All

I have bulit a userform in which there is one combobox that stores the values present in a column in excel sheet. Now my problem is when I process one item ,I want to remove that item from a combobox although it is present in excel sheet.

How to remove the selected item in a combobox..Could anyone please provide me vba code for this

Regards
Aman

**Leith Ross** · 02-23-2009, 07:01 PM

Hello aman124,

Welcome to the Forum!

You can remove an item from a ComboBox provided it is not linked to a range. To remove the item, you must get the ListIndex value of the selected item. This index value is used with the RemoveItem method.

Remove the First Entry of the ComboBox

Please Login or Register  to view this content.

**aman1234** · 02-24-2009, 02:09 AM

Hi

How can i find Listindex value of the selected item..thats is my problem ..i tried various methods but they don't work e.g

1. ComboBox1.RemoveItem ComboBox1.ListIndex
2. Private Sub cmdDelete_Click()
'For I = 0 To ComboBox1.ListCount - 1

'If ComboBox1.ListIndex(I) = Val(ComboBox1.Text) Then
' ComboBox1.RemoveItem (ComboBox1.ListIndex)

'Exit For
'End If
'Next

can you please helpme..
Regards
Aman

3. ComboBox1.RemoveItem (ComboBox1.ListIndex)

**Leith Ross** · 02-24-2009, 03:07 AM

Hello aman1234,

It would help to see the code you have written or a sample workbook. I can then give you a specific answer to this problem.

**aman1234** · 03-06-2009, 08:19 AM

Hi Leith

Could be please see my thread "Problem in comparing dates". As last time u solved my problem very quickly.Could you please try to solve this problem too.

Regards
Aman