Displaying Unique Values in a Combobox

  • Thread starter Thread starter Todd Htuttenstine
  • Start date Start date
T

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
 
Back
Top