Duplicate numbers in a listbox

[MJW]

Hi everyone,

I have a combobox filled with numbers, some of which appear several times, but i would like each number only to appear on the list once. This list will also increase as i add new entries.

Is it possible to add items to this list once rather than have duplicate entires?

Thanks in advance for any help!

 

[TommyGun]

Are the values in your list built from a Range of values, or are they stored elsewhere (i.e. in code, file, or database)?

 

[MJW]

From a range.

 

[Alan Nicoll]

I don't know that a function exists to do this for you. You can certainly do a brute-force item-by-item check. That is:

Take item in list
Delete all subsequent occurrences of that item
Repeat until end of list encountered

HTH

Alan

 

[TommyGun]

Can you post the code you use to add items to this list (range)?

 

[Alan Nicoll]

Can you post the code you use to add items to this list (range)?

Not quite sure what you're asking. If the data is in a spreadsheet you bind the list to the cells using something like:
UserForm1.ListBox1.RowSource =

#VALUE!

 

[TommyGun]

Well, seeing as the items need to be added to the range in some way (either manually or via code), this is probably the best place to check for duplicates.