I want to populate a list box with data from a column in excel. say
column a sheet 1. the data in the column will have repeated data in
it, but i only want this data added once in the listbox.

e.g column a could be

red
blue
red
yellow
blue
red
red
yellow

but i only want to display in the ist box

red
blue
yellow


I know how to populate a listbox based on a range but cant seem to
work this out

hope someone can help

John