Validation list

  • Thread starter Thread starter Ulf Nilsson
  • Start date Start date
U

Ulf Nilsson

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
 
Back
Top