Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation list
Hi, I have two validation lists. If I change the first list, I want the second list to adjust to the choice made. For example: If I choose "Fruits" from List 1, I want the result to be in List 2: Apple, Bananas, Lemon If I choose "Countries" from List 1, I want the result to be in List 2: USA, Taiwan, Iraq I know how to get information from txt-files and how to populate the validation lists. I use "Workbook_SheetChange" to look for changes. How do I find out if it is one of the Validation lists the user is changing? Please ask more if something is unclear. // Ulf |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation list
for the first validation list, use the items to range name the other lists so if your main list is Countries, Fruits have a table of countries range named countries and a table of fruits range named fruits your 2nd validation the LIST and the source is =INDIRECT(A1) - replace A1by whatever the cell is for the 1st validation cell example file: http://cid-b8e56c9a5f311cb7.skydrive...Validation.xls "Ulf Nilsson" wrote in message ... Hi, I have two validation lists. If I change the first list, I want the second list to adjust to the choice made. For example: If I choose "Fruits" from List 1, I want the result to be in List 2: Apple, Bananas, Lemon If I choose "Countries" from List 1, I want the result to be in List 2: USA, Taiwan, Iraq I know how to get information from txt-files and how to populate the validation lists. I use "Workbook_SheetChange" to look for changes. How do I find out if it is one of the Validation lists the user is changing? Please ask more if something is unclear. // Ulf |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation list
Hi, Debra Web has exactly the same example http://www.contextures.com/xlDataVal02.html "Ulf Nilsson" wrote: Hi, I have two validation lists. If I change the first list, I want the second list to adjust to the choice made. For example: If I choose "Fruits" from List 1, I want the result to be in List 2: Apple, Bananas, Lemon If I choose "Countries" from List 1, I want the result to be in List 2: USA, Taiwan, Iraq I know how to get information from txt-files and how to populate the validation lists. I use "Workbook_SheetChange" to look for changes. How do I find out if it is one of the Validation lists the user is changing? Please ask more if something is unclear. // Ulf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use VBA to reset data validation (=list) value to first value in that list (list is a named range) | Excel Programming | |||
data validation invalid in dynamic validation list | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming |