Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing a listbox from excel spreadsheet | Excel Worksheet Functions | |||
Removing Data Validation (Listbox) | Excel Worksheet Functions | |||
Removing items from listbox | Excel Programming | |||
trouble removing rows | Excel Programming | |||
removing selection focus in listbox | Excel Programming |