listbox help
 

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

listbox help
 

sorry its not a listbox, its actually a dropdown combo. so sorry
--
please can you help... its urgent


"Moh" wrote:

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

listbox help
 

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)

"Moh" wrote in message
...
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