Displaying Unique Values in a Combobox
 

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

Displaying Unique Values in a Combobox
 

Todd,

John Walkenbach has a tip for this at:

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

hth,

Doug

"Todd Htuttenstine" wrote in message
...
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

Displaying Unique Values in a Combobox
 

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


-----Original Message-----
Todd,

John Walkenbach has a tip for this at:

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

hth,

Doug

"Todd Htuttenstine"
wrote in message
...
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



.