On Jan 23, 12:07*pm, Greg Glynn wrote:
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

thanks, just been thinking i think i would need to use a combo box
instead of a list, would the code be much different

john