Hi,

I hope someone can help me... is there a way to have a combobox on a
userform get its list populated from the contents of 'pick from list' (that
you have when you right click on a cell in a table of data)? I want the
combobox to have a list based on what has already been entered in the
column, but not include duplicates (so even if i can't access the values i
'pick from list', maybe there is some other way?).

i hope that makes sense, tia,

Tim