Dear Pros,

I am a beginner in excel vba and i need some guide.

I have an userform and it contain a combobox, a button and a textarea.
There are four options in my combobox (red, blue, yellow, white and green)
and the textarea is use to display purpose.

I have a worksheet name "color", there are 2 columns, one column is call StudentName and another is call Color.


Column1 Colomn 2
StudentName Color
Alex red
Aziz yellow
Abu blue
Ali red, green
Rose red, white


May i know is that possible to let the user select an option in the combobox and click the button, so that the command will check my worksheet which is name "color", and display the "StudentName" into a textarea. (Let's say the user select red in the combo box, and inside my worksheet"color", there are 3 students have red color, so the textarea will display Alex, Abu and Rose)

I would appreciate if any can guide me. Thank you in advances.