ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Trouble Removing a value from a ListBox (https://www.excelbanter.com/excel-programming/374910-trouble-removing-value-listbox.html)

trward79

Trouble Removing a value from a ListBox
 
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.


trward79

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.



All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com