Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking list box
Here's what I need to do...I have some list boxes created, and I have them
linked together. However, I need the item in list box 2 to change based on what list box 1 is. For Example In list box 1 I have 3 entries of inventory id's being "a","b", and "c" In list box 2 I have 3 entries of what I have on hand being "1", "2", and "3" now lets say that I have "3" of a when I click list box 1 and set it to "a" I want list box 2 to automatically select "3" is there a way to do this with excel? Thanks Jamesmor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking list box
Of course. What sort of listbox?
-- HTH RP (remove nothere from the email address if mailing direct) "Jamesmor" wrote in message ... Here's what I need to do...I have some list boxes created, and I have them linked together. However, I need the item in list box 2 to change based on what list box 1 is. For Example In list box 1 I have 3 entries of inventory id's being "a","b", and "c" In list box 2 I have 3 entries of what I have on hand being "1", "2", and "3" now lets say that I have "3" of a when I click list box 1 and set it to "a" I want list box 2 to automatically select "3" is there a way to do this with excel? Thanks Jamesmor |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking list box
I'm just using the ones created by "data"- "validation"
"Bob Phillips" wrote: Of course. What sort of listbox? -- HTH RP (remove nothere from the email address if mailing direct) "Jamesmor" wrote in message ... Here's what I need to do...I have some list boxes created, and I have them linked together. However, I need the item in list box 2 to change based on what list box 1 is. For Example In list box 1 I have 3 entries of inventory id's being "a","b", and "c" In list box 2 I have 3 entries of what I have on hand being "1", "2", and "3" now lets say that I have "3" of a when I click list box 1 and set it to "a" I want list box 2 to automatically select "3" is there a way to do this with excel? Thanks Jamesmor |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking list box
I am just a regular user of excel, but have done something similar before
with combo boxes and the HLOOKUP function for the first combo box, I had the ListFillRange listed in F5:F7 (example - mine was a little more complicated), with the LINKEDCELL in G5 As the user Picked the appropriate option in the combo box, the value in G5 changes to the desired value Lets say the three choices are Option 1 Option 2 Option 3 I had the second combo box ListFill Range listed in H5:H7 I had a small table listed further J5:L8 over in the spreadsheet that had in each column Option 1 Option 2 Option 3 Bob Jane Mary Mark Doug Deanna Heather Katie Mike In the cells H5 I had =HLOOKUP(TRIM($G$5),$J$5:$L$8,2,FALSE) in H6 I had =HLOOKUP(TRIM($G$5),$J$5:$L$8,3,FALSE) in H7 I had =HLOOKUP(TRIM($G$5),$J$5:$L$8,4,FALSE) The way it works is the first combo picks which column will populate the data in H5:H7 The Horizontal Lookup fills the data The data is then available for the second combo box Like I said - I am just a average user, there are probably bette ways of doing this "Jamesmor" wrote: I'm just using the ones created by "data"- "validation" "Bob Phillips" wrote: Of course. What sort of listbox? -- HTH RP (remove nothere from the email address if mailing direct) "Jamesmor" wrote in message ... Here's what I need to do...I have some list boxes created, and I have them linked together. However, I need the item in list box 2 to change based on what list box 1 is. For Example In list box 1 I have 3 entries of inventory id's being "a","b", and "c" In list box 2 I have 3 entries of what I have on hand being "1", "2", and "3" now lets say that I have "3" of a when I click list box 1 and set it to "a" I want list box 2 to automatically select "3" is there a way to do this with excel? Thanks Jamesmor |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking list box
This has helped out a bunch, however, I'm still running into a problem, the
values for my list box are in another spreadsheet and it looks as if this only works with everything being on a single sheet (I could be mistaken). Is this the case? "Mykal" wrote: I am just a regular user of excel, but have done something similar before with combo boxes and the HLOOKUP function for the first combo box, I had the ListFillRange listed in F5:F7 (example - mine was a little more complicated), with the LINKEDCELL in G5 As the user Picked the appropriate option in the combo box, the value in G5 changes to the desired value Lets say the three choices are Option 1 Option 2 Option 3 I had the second combo box ListFill Range listed in H5:H7 I had a small table listed further J5:L8 over in the spreadsheet that had in each column Option 1 Option 2 Option 3 Bob Jane Mary Mark Doug Deanna Heather Katie Mike In the cells H5 I had =HLOOKUP(TRIM($G$5),$J$5:$L$8,2,FALSE) in H6 I had =HLOOKUP(TRIM($G$5),$J$5:$L$8,3,FALSE) in H7 I had =HLOOKUP(TRIM($G$5),$J$5:$L$8,4,FALSE) The way it works is the first combo picks which column will populate the data in H5:H7 The Horizontal Lookup fills the data The data is then available for the second combo box Like I said - I am just a average user, there are probably bette ways of doing this "Jamesmor" wrote: I'm just using the ones created by "data"- "validation" "Bob Phillips" wrote: Of course. What sort of listbox? -- HTH RP (remove nothere from the email address if mailing direct) "Jamesmor" wrote in message ... Here's what I need to do...I have some list boxes created, and I have them linked together. However, I need the item in list box 2 to change based on what list box 1 is. For Example In list box 1 I have 3 entries of inventory id's being "a","b", and "c" In list box 2 I have 3 entries of what I have on hand being "1", "2", and "3" now lets say that I have "3" of a when I click list box 1 and set it to "a" I want list box 2 to automatically select "3" is there a way to do this with excel? Thanks Jamesmor |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking list box
Never Mind, I got it working, had to use Vlookup instead but it works fine.
Thanks! "Mykal" wrote: I am just a regular user of excel, but have done something similar before with combo boxes and the HLOOKUP function for the first combo box, I had the ListFillRange listed in F5:F7 (example - mine was a little more complicated), with the LINKEDCELL in G5 As the user Picked the appropriate option in the combo box, the value in G5 changes to the desired value Lets say the three choices are Option 1 Option 2 Option 3 I had the second combo box ListFill Range listed in H5:H7 I had a small table listed further J5:L8 over in the spreadsheet that had in each column Option 1 Option 2 Option 3 Bob Jane Mary Mark Doug Deanna Heather Katie Mike In the cells H5 I had =HLOOKUP(TRIM($G$5),$J$5:$L$8,2,FALSE) in H6 I had =HLOOKUP(TRIM($G$5),$J$5:$L$8,3,FALSE) in H7 I had =HLOOKUP(TRIM($G$5),$J$5:$L$8,4,FALSE) The way it works is the first combo picks which column will populate the data in H5:H7 The Horizontal Lookup fills the data The data is then available for the second combo box Like I said - I am just a average user, there are probably bette ways of doing this "Jamesmor" wrote: I'm just using the ones created by "data"- "validation" "Bob Phillips" wrote: Of course. What sort of listbox? -- HTH RP (remove nothere from the email address if mailing direct) "Jamesmor" wrote in message ... Here's what I need to do...I have some list boxes created, and I have them linked together. However, I need the item in list box 2 to change based on what list box 1 is. For Example In list box 1 I have 3 entries of inventory id's being "a","b", and "c" In list box 2 I have 3 entries of what I have on hand being "1", "2", and "3" now lets say that I have "3" of a when I click list box 1 and set it to "a" I want list box 2 to automatically select "3" is there a way to do this with excel? Thanks Jamesmor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Drop Down List | Excel Worksheet Functions | |||
Drop down list linking | Excel Worksheet Functions | |||
Linking to dopdown list | New Users to Excel | |||
Ooh .. Linking a list to a list to an output cell | Excel Discussion (Misc queries) | |||
Linking List | Excel Worksheet Functions |