Using VBA to extract Student's data

[thnah phan]

I have a worksheet containing students' data as follow:
(in row) Number, Student ID, Name, Birthday, average score, score of sub 1, score of sub 2, score of sub 3.

Now I have to create (in VBA) a combobox for users to choose an ID, then a Msgbox will appear with the results of Name, Avg Score and Scores of each sub.

But im' beginner in VBA, can anyone help me the code, or how to make it

Thks alot.

[Sindhus]

Try this code. I assumed your data is in columns A to G and combo box in I1.

Please Login or Register  to view this content.

[thnah phan]

Sorry I didnt explain well, I dont use combobox in excel but use a userform in VBA, then choose the button "combobox", therefore, there's no combobox in I1.

Can u help me one more time, thks alot :D

[Sindhus]

Then try the code this way. Target = Userform1.Combobox1.value to get value from combo box. Userform1 is your userform name and combobox1 is your combo box name. Then use this part in your code.

Please Login or Register  to view this content.