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