REMOVE.LIST.ITEM

Macro Sheets Only

Removes an item in a list box or drop-down box.

Syntax

REMOVE.LIST.ITEM(index_num, count_num)

Index_num specifies the index of the item to remove, from 1 to the number of items in the list. Specify zero to remove all items in the list.

Count_num Specifies the number of items to delete starting from index_num. If omitted, only one item is removed.

Remarks

If count_num + index_num is greater than the number of items in the list, all items starting with index_num to the end of the list are removed.

Examples

REMOVE.LIST.ITEM(3,2) removes two items starting with the third item

REMOVE.LIST.ITEM(3) removes only the third item

Related Functions

LISTBOX.PROPERTIES Sets the properties of a list box and drop-down controls on worksheet and dialog sheets

List of Customizing Functions