listbox help

G

Guest

morning all programmers,

i have a small problem, i got 2 worksheets in excel.
in worksheet 1 i have a listbox and a textbox
the information is all in sheet 2
the information is in columns A and B
In the listbox i have a list of all the information from cell a1 to a50
now when they select anything from the list, i need the data from column B
to appear in either the textbox or if easier (cell h2 in sheet1)

this is how the data should be linked in return as follows:

a1 will be linked to b1
a2 will be linked to b2
a3 will be linked to b3
a4 will be linked to b4
..... etc til a50

can someone help please?

Many Thanks
 
B

Bob Phillips

Just link cell H2 to the listbox and also the textbox to the same cell.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

Top