Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
Im sorry if this has appeared before but my server isnt showing it.
Can I ask for some help for removing an item from a listbox? I wish to add a remove item button. the listbox is lb1 and the sheetname name it is rowsource to is checkout range a2:d15 Thanks in advance Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox
This statement is in the VBA help file for RowSource:
This method will not remove a row from the list if the ListBox is data bound (that is, when the RowSource property specifies a data source for the ListBox). What this means is that if you use RowSource to load your list box, then you have to modify the row source range to delete an item. You cannot use the RemoveItem method on a listbox or combobox unless you load it with the additem or list methods. "Greg B" wrote: Im sorry if this has appeared before but my server isnt showing it. Can I ask for some help for removing an item from a listbox? I wish to add a remove item button. the listbox is lb1 and the sheetname name it is rowsource to is checkout range a2:d15 Thanks in advance Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |