Listbox Item remove

[thameem127]

How do I remove an item from list after double click an item. Help me please .

[Domenic]

Assuming that the ListBox is not data bound, maybe...

Please Login or Register  to view this content.

[thameem127]

It shows an error

[Domenic]

Is your ListBox located on a UserForm or worksheet? If it's located on a worksheet, is it a form control or an ActiveX contrtol?

[thameem127]

Is your ListBox located on a UserForm or worksheet? If it's located on a worksheet, is it a form control or an ActiveX contrtol?

It is located in worksheet

[thameem127]

It is located worksheet

[Domenic]

I think you'll need to make sure that the ListBox is an ActiveX control, not a Form control. Note that the data source for the ListBox cannot be specified by the ListFillRange property. Have a look at the attached sample workbook.

[thameem127]

Sorry for the late reply....

Thanks a lot....
Another one thing . In the List box 1 selected item to be copied to range A1 and removed from the list box 1 list item and then next selected item copied to range A2 . next item A3... and then removed from the list box list item any idea

[Domenic]

Once the item in the ListBox is double-clicked, the following code copies it to the first available row in Column A of the worksheet, and removes it from the ListBox...

Please Login or Register  to view this content.

[thameem127]

Lot more thanks Mr. Domenic

[Domenic]

You're very welcome!