userform display based on combobox selection

Hi.

I have a simple worksheet with 2 columns

Column A has "Commodities" and Column B has "Requirements"

On my userform, I am going to have a combobox to display Column A and I would like the data in Column B to display in a scrolling text box

So if the user selects a "commodity" it will display the corresponding requirement.

For example if someone selects "Apple"(which is in A2) it will display the "Requirement"(which is in B2) in the scrolling textbox.

Any one able to help or able to point me in the right direction for a google search.

If you can provide a sample workbook with your userform and some data I'm sure we can help you out.

Try sample file.
Combobox gives you sorted list of all Commodities of Search sheet. On selecting an item Requirements appear in Label.

See if this works for you.
Have added Combobox at bottom of userform to select commodity. Second userform will popup with requirements.

This should be it.

You're welcome. Thanks for adding rep points.
Good luck with your project.