how can i list unique values in a combobox from a range? have about 40 rows, 1
column with about 5 unique descriptors i want to list and have the user select
one.

tried advanced filter and it shows the unique values in the range, but i
couldn't populate the combobox with the unique entries.

--


Gary

this worked unless someone has a better idea

Worksheets("emp").Range("g2:g40").AdvancedFilter _
xlFilterCopy, , Range("Q2"), True
glastrow = Worksheets("emp").Range("Q100").End(xlUp).Row
With Me.ComboBox1

..RowSource = "Q2:Q" & glastrow
End With

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
how can i list unique values in a combobox from a range? have about 40 rows, 1
column with about 5 unique descriptors i want to list and have the user select
one.

tried advanced filter and it shows the unique values in the range, but i
couldn't populate the combobox with the unique entries.

--


Gary

this isn't really cooperating. i can't set the row source to a hidden sheet. any
way around this?

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
how can i list unique values in a combobox from a range? have about 40 rows, 1
column with about 5 unique descriptors i want to list and have the user select
one.

tried advanced filter and it shows the unique values in the range, but i
couldn't populate the combobox with the unique entries.

--


Gary

i think i have it

"'Sheet1'!Q2:Q" & lastrow

doing pretty good responding to my own posts<g
--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
this isn't really cooperating. i can't set the row source to a hidden sheet.
any way around this?

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
how can i list unique values in a combobox from a range? have about 40 rows,
1 column with about 5 unique descriptors i want to list and have the user
select one.

tried advanced filter and it shows the unique values in the range, but i
couldn't populate the combobox with the unique entries.

--


Gary