Populating Text Boxes from a ComboBox on a Userform

Hi Terry,
I'm not clear on your layout, but maybe you can adapt this to something that'll help.

Assuming your combobox data is in column A, and you want textbox1 to return what's in column B of the combobox choice, textbox2 to return column C, textbox3, to return column D, (etc.) then here's some code you can try for the combobox. If this is completely off base then post back with a more detailed description of your layout and desired results.

Hope it helps,
Dan

Dan
Many thanks for such a quick reply.
I'll give your suggestion a try and will come back with either thanks or need more help as offered.
Terry

Hi Dan
I have just one 'small' problem.
That is, the sheet I'm looking up is a different one to the one that the userform is used on. The sheet is named Finance (2)
and I cannot seem to grasp the sintax.
Private Sub ComboBox1_Change()
Dim i As Long
i = [a65536].End(xlUp).Row
For x = 1 To i
If Cells(x, 1).Value = ComboBox1.Value Then
TextBox7.Value = Cells(x, 1)(1, 2).Value
TextBox8.Value = Cells(x, 1)(1, 3).Value
TextBox9.Value = Cells(x, 1)(1, 4).Value
TextBox10.Value = Cells(x, 1)(1, 5).Value
End If
Next x
End Sub

Dan
Thanks for your help I've cracked it. Embarrasingly simple really.
I used the screenupdating = false/true and it's just great.

Most welcome. Glad you got it working the way you want.

Dan