Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |