| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add item to listbox, but only if it is not already there.
I am trying to write code so that if an item is selected in one listbox, it
will be added to another listbox. However, it should only be added if it does not already exist in the second listbox. Why is the following code doing nothing. It make logical sense, to me. For i = 0 To UserForm1.ColumnSelect.ListCount - 1 If UserForm1.ColumnSelect.Selected(i) Then For j = 0 To UserForm1.ColFilter.ListCount If UserForm1.ColumnSelect.List(i) < UserForm1.ColFilter.List(j) Then UserForm1.ColFilter.AddItem UserForm1.ColumnSelect.List(i) End If Next j End If Next i |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Last Item of Listbox not getting displayed | Excel Discussion (Misc queries) | |||
| Item order in ListBox | Excel Discussion (Misc queries) | |||
| listbox remove Item | Excel Programming | |||
| Opening item from Listbox... Need Help :P | Excel Programming | |||
| The value of a ListBox Item | Excel Programming | |||
Threaded Mode
