View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charles Chickering Charles Chickering is offline
external usenet poster
 
Posts: 272
Default Removing a value question

Try:
Me.ListBox2.RemoveItem Me.ListBox2.ListIndex
--
Charles Chickering

"A good example is twice the value of good advice."


"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.