Combobox populate textbox

[samtwilliams]

I am trying to create an updating tools for updating records in a small table in excel.

I have used the following code;

Please Login or Register  to view this content.

This works to some extent but nto as far as i want it.
I want to be able to select a name in the combo box and for his/hers details to be populated into text boxs below. All i get at present is the values listed in ROW 1.

Can anyone help
Thanks
Sam

[royUK]

Not sure why you are using UserForm_Click, you should use Combobox_Change. Also you need to refer to the Column as a number

Please Login or Register  to view this content.