ControlFormat.RemoveItem Method
| Excel Developer Reference |
Removes one or more items from a list box or combo box.
Syntax
expression.RemoveItem(Index, Count)
expression A variable that represents a ControlFormat object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Index | Required | Long | The number of the first item to be removed. Valid values are from 1 to the number of items in the list (returned by the ListCount property). |
| Count | Optional | Variant | The number of items to be removed, starting at item Index. If this argument is omitted, one item is removed. If Index + Count exceeds the number of items in the list, all items from Index through the end of the list are removed without an error. |
Remarks
If the specified object has a fill range defined for it, this method fails.
Use the RemoveAllItems method to remove all entries from a Microsoft Excel list box or combo box.
Example
This example removes the selected item from a list box. If Shapes(2) doesn’t represent a list box, this example fails.
| Visual Basic for Applications |
|---|
|
See Also