| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
| avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
| VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Linear Mode
