Populating a listbox from an excel column
Hi John,
Each time you pick up a new entry, loop through the listbox entries
you already have to see if there is a duplicate.
'Create a For Next Loop to read all the items in the List Box
For Item = 0 to ListBox.ListCount - 1
If ListBox.List(Item) < {your next candidate} then
(Add the candidate to the list)
Exit for
else
'Duplicate, do nothing
end if
Next item
|