Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form lists influencing other lists
I'm using Excel 2000 with WinXP. I have a data sheet with several combo boxes. This sheet is supposed to return information based on what the user selects in a few combo boxes. The user can set the data in these combo boxes based on items they have present. Each item has a quality that I want displayed in another cell. I also want another list of items to come up based on the first choice in another combo box. Here is a simplified example of my sheet: Combo Box 1 in cell A1 contains: Roses Daisies Tulips When the user selects Roses cell B1 displays the word: Red. When the user selects Daisies cell B1 displays the word: Yellow. When the user selects Tulips cell B1 displays the word: White. When the user selects Roses the Combo Box in cell C1 has the following choices: Longstem Miniture When the user selects Daisies the Combo Box in cell C1 has the following choices: Wild Loose When the user selects Tulips the Combo Box in cell C1 has the following choices: Bouqette Potted Oh, and to add one more item to the fire, how can I get my Combo Boxes to have a default view with no input? Thanks for any help you can provide. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form lists influencing other lists
Debra Dalgleish has some techniques for using dependent lists with
data|validation at: http://www.contextures.com/xlDataVal02.html And a way to create a name for a dynamic range at: http://www.contextures.com/xlNames01.html#Dynamic You could use the same techniques with your comboboxes. chanteribby wrote: I'm using Excel 2000 with WinXP. I have a data sheet with several combo boxes. This sheet is supposed to return information based on what the user selects in a few combo boxes. The user can set the data in these combo boxes based on items they have present. Each item has a quality that I want displayed in another cell. I also want another list of items to come up based on the first choice in another combo box. Here is a simplified example of my sheet: Combo Box 1 in cell A1 contains: Roses Daisies Tulips When the user selects Roses cell B1 displays the word: Red. When the user selects Daisies cell B1 displays the word: Yellow. When the user selects Tulips cell B1 displays the word: White. When the user selects Roses the Combo Box in cell C1 has the following choices: Longstem Miniture When the user selects Daisies the Combo Box in cell C1 has the following choices: Wild Loose When the user selects Tulips the Combo Box in cell C1 has the following choices: Bouqette Potted Oh, and to add one more item to the fire, how can I get my Combo Boxes to have a default view with no input? Thanks for any help you can provide. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists from multiple source lists | Excel Worksheet Functions | |||
Excel 2003 - Customise a Data Form for dropdown lists | Excel Discussion (Misc queries) | |||
LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
how do I add data validation dropdown lists to a Form | Excel Worksheet Functions |