I have several combo boxes and the will all be filled in by scanning
barcodes, they get their contents for a range on a second sheet, and I need
to fill in a text box with the contents of the cell to the right of the
number in the combo box
A B
12334 Earl
32211 Tom

So the cbobox gets its data from A and I want the txtbox to have B

Thanks

OK so I mostly found my answer, thanks to K Dales for his answer to another
question

txtOpBox.Value = Range("data!A2").Offset(cboName.ListIndex, 1)

So now all I need to do is have it put the data from the text box in to the
form.


"Llamadon" wrote:

I have several combo boxes and the will all be filled in by scanning
barcodes, they get their contents for a range on a second sheet, and I need
to fill in a text box with the contents of the cell to the right of the
number in the combo box
A B
12334 Earl
32211 Tom

So the cbobox gets its data from A and I want the txtbox to have B

Thanks