Index & Match in UserForm

Hello

As my title says i would like to have an Index & match function in my userform.

I know that i must use it like this Application.WorksheetFunction but i am not able to do it.

User select a code and then in next text boxes, description and price should appear.

Can you help me on this pls?

Why not use the ListIndex of the combobox to get the row the selected code is on?

Because...i don't know how to do that Mr Norie!

Can you pls advice?

Something like this.

Please Login or Register  to view this content.

Easy when you know how to do this.

Thank you very much Mr Norie!!

1 question.

Please Login or Register  to view this content.

What does the +2??

ListIndex starts at 0, the range you are populating the combobox starts at row 2, so we add 2 to get the row.

Thank you!!