Thread: Validation list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ulf Nilsson[_2_] Ulf Nilsson[_2_] is offline
external usenet poster
 
Posts: 1
Default 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