Part | Description | |
object | Required. A valid object. | |
Item | Optional. Specifies the item or row to add. The number of the first item or row is 0; the number of the second item or row is 1, and so on. | |
varIndex | Optional. Integer specifying the position within the object where the new item or row is placed. |
Dim EntryCount As Single
Private Sub CommandButton1_Click()
EntryCount = EntryCount + 1
ListBox1.AddItem (EntryCount & " - Selection")
End Sub
Private Sub CommandButton2_Click()
ListBox1.SetFocus
'Ensure ListBox contains list items.
If ListBox1.ListCount >= 1 Then
'If no selection, choose last list item.
If ListBox1.ListIndex = -1 Then
ListBox1.ListIndex = ListBox1.ListCount - 1
End If
ListBox1.RemoveItem (ListBox1.ListIndex)
End If
End Sub
Private Sub UserForm_Initialize()
EntryCount = 0
CommandButton1.Caption = "Add Item"
CommandButton2.Caption = "Remove Item"
End Sub