View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Greg Glynn Greg Glynn is offline
external usenet poster
 
Posts: 137
Default 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