Populate combo with values from one column and text boxes from other columns

Polpulate combo box with cell value and text box wit other cell values
My question is i have a sheet with several colomns and several values , i want to fill a combo box wirh values lets say from column a and also several text boxes simultaneously with the values of column b c ...
and when i chhose a value from the combo box corresponding to a diferent row in my sheet automaticaly that changes the values in the text boxes , is this clear?

A B C
v1 v2 v3
v4 v5 v6

so if I choose v1 from the combo bos the text boxes will have v2 and v3 but if I choose v4 from the combo then the text boxes will have v5 and v6

even more I would like that the row A from where I pick the values to the combo is endless, i.e. ' not depending of a certain range so i need some methof to look for the last row with values to fill the combo this is to be used in a form I'm doing

Thanks and regs

Tea

Please Login or Register  to view this content.

Thx it works but reads the first row where the headers are how to overcame this ?
rgs
Tea_4_2

Please Login or Register  to view this content.

THX a lot
Best Regards
Tea_4_2

You're welcome.