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.