How could I change the first combobox to only show the first instance of a
value/text? Right now the way it is it shows all the values in column A, so
like I showed the combobox would only show apple,pear,grape, not all the
apples?

"Mekinnik" wrote:

I am trying to create code for my user form that would use a combobox
selection as the first criteria and search cloumn 'B' for every of that value
that has the name within the same row or something like that and add the
values to a combobox drop down list. I would look something like this:

col. 'A' col. 'B'
apple red
apple green
apple yellow
pear green
grape purple
apple pink

for every 'apple' in column 'A' it will add the color in column 'B' to the
drop down list.

I would like this to happen in the userform initialize event, so that when
the second userform opens the dropdown list is allready populated, also if it
doesn't find any matches it will show a msgbox.