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