combox question

G

Gary Keramidas

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.
 
G

Gary Keramidas

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
 
G

Gary Keramidas

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

Gary Keramidas

i think i have it

"'Sheet1'!Q2:Q" & lastrow

doing pretty good responding to my own posts<g>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced Filter Error - I cannot spot my Error 3
Listbox populated based on Combobox 2
"Run-time error '1004' 5
Advanced Filter - Get the unique rows 2
range of unique cells 6
Populating a combobox 2
Transfer AutoFiler list to a ComboBox 8
non-repeating Comboboxes values 9

Top