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

Thanks Charles. This fixed it right up. It removed the value.

"Charles Chickering" wrote:

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.