gadz
04-13-2006, 04:26 AM
Edited by lucas, reason: cross-posted
Click here (http://www.excelguru.ca/XLKBA/XLKBA05.htm) for an explanation of cross-posting
I think I jumped in over my head. :dunno :banghead:
(Please see attchment to understand this post!)
Part 1:
I want to be able to choose an option from the (background) combobox on the Display worksheet that filters what is displayed in the (names) listbox.
For example if I choose "Yellow" from the dropdown, the listbox should only show names (from the data sheet) that have that same value in its row. If I choose "Show All" from the dropdown, the listbox should show all of the names regardless of the background value.
Part 2:
When you click on a name in the listbox, I want it to look for the "background" value of the name (on the Data sheet, eg. "Yellow") and then get the 3 matching lists (eg. "Yellow 1.1-9", "Yellow 2.1-9", "Yellow 3.1-9") and display them on the Display sheet in the columns where it says "List 1", "List 2", and "List 3".
Part 3:
This bit is the trickiest of them all I think and I don't even know if it can be done. The columns on the "Display" sheet that have the ticks: I need to be able to double click a cell in that column to add a virtual tick (double-click a cell in the first column for an example) that will grey out the text in the cell on its right (conditional formatting takes care of this easily)...but the catch is that I need each name to remember which cells were ticked for that name so that they are different on each name regardles of what 3 lists they have showing.
For example: If I click the name "Bobby Smith" from the listbox, it will show the 3 "Yellow" lists because Bobby Smith has the background value "Yellow" in its row on the Data sheet. Now if I double click E5 and E6 it will tick these cells greying out the cells on the right of them. If I now change the name to Peter Smith who also has the background value "Yellow" it will show me the 3 "Yellow" lists but nothing will be ticked because it's a different name. Clicking back on Bobby Smith those cells will be ticked again.
Is this even possible?
I want to avoid having a different sheet for each name if at all possible.
I hope someone can help me figure this out, I've been at it for three days now. I don't know all that much excel and I've been learning as I go along but I'm really excited at the seeming posibilities.
Click here (http://www.excelguru.ca/XLKBA/XLKBA05.htm) for an explanation of cross-posting
I think I jumped in over my head. :dunno :banghead:
(Please see attchment to understand this post!)
Part 1:
I want to be able to choose an option from the (background) combobox on the Display worksheet that filters what is displayed in the (names) listbox.
For example if I choose "Yellow" from the dropdown, the listbox should only show names (from the data sheet) that have that same value in its row. If I choose "Show All" from the dropdown, the listbox should show all of the names regardless of the background value.
Part 2:
When you click on a name in the listbox, I want it to look for the "background" value of the name (on the Data sheet, eg. "Yellow") and then get the 3 matching lists (eg. "Yellow 1.1-9", "Yellow 2.1-9", "Yellow 3.1-9") and display them on the Display sheet in the columns where it says "List 1", "List 2", and "List 3".
Part 3:
This bit is the trickiest of them all I think and I don't even know if it can be done. The columns on the "Display" sheet that have the ticks: I need to be able to double click a cell in that column to add a virtual tick (double-click a cell in the first column for an example) that will grey out the text in the cell on its right (conditional formatting takes care of this easily)...but the catch is that I need each name to remember which cells were ticked for that name so that they are different on each name regardles of what 3 lists they have showing.
For example: If I click the name "Bobby Smith" from the listbox, it will show the 3 "Yellow" lists because Bobby Smith has the background value "Yellow" in its row on the Data sheet. Now if I double click E5 and E6 it will tick these cells greying out the cells on the right of them. If I now change the name to Peter Smith who also has the background value "Yellow" it will show me the 3 "Yellow" lists but nothing will be ticked because it's a different name. Clicking back on Bobby Smith those cells will be ticked again.
Is this even possible?
I want to avoid having a different sheet for each name if at all possible.
I hope someone can help me figure this out, I've been at it for three days now. I don't know all that much excel and I've been learning as I go along but I'm really excited at the seeming posibilities.