J
john.9.williams
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
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