View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
trward79 trward79 is offline
external usenet poster
 
Posts: 20
Default Trouble Removing a value from a ListBox

ALready Answered... Sorry for the duplicate Post!

"trward79" wrote:

Current Code:

Private sub CommandButton5_Click()
If Me.ListBox2.Value < "" Then
Me.ListBox2.RemoveItem Me.ListBox2.Value
End If
End Sub

I keep getting an error of Invalid Argument and it debugs to line 3 of this
code sniplet. Please let me know if there is another way I can do this. It
needs to take the selected value from ListBox2 when the button is clicked.