Displaying Unique Values in a Combobox

[Todd Htuttenstine]

I have combobox1 which references Values in Column A.
There may be multiple
values with the same name in this Column. For example if
the value "Todd"
was in the Column in 4 different locations, the combobox
will display the
value "Todd" 4 times in the order in which they occur in
the Column. I do
not want this.

My code is below
ComboBox1.RowSource = "OFFSET(" & Worksheets(1).Name & "!
A1,,,COUNTA(" &
Worksheets(8).Name & "!A:A))"

How do I modify or what do I add to this code to make it
list only unique
values?

Thank you

Todd Huttensitne

 

[Doug Glancy]

Todd,

John Walkenbach has a tip for this at:

http://j-walk.com/ss/excel/tips/tip47.htm

hth,

Doug

 

[Todd Huttenstine]

Thank you. Will take a look at that when I get home.