Update txtbox from combobox

G

Guest

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top