SET.LIST.ITEM

Macro Sheets Only

Sets the text of an item in a list box or drop-down box control.

Syntax

SET.LIST.ITEM(text, index_num)

Text specifies the text of the item to be added. Instead of text, an empty string may be inserted.

Index_num is the list index of the item to be changed, from 1 to the number of items in the list.

Remarks

If the list box or drop-down box was already filled using the LISTBOX.PROPERTIES function, then changing an item with SET.LIST.ITEM causes the fillrange contents to be discarded, leaving a list with one non-blank element and index_num entries.

Related Functions

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

SELECT.LIST.ITEM Selects an item in a list box or in a group box

List of Customizing Functions