create drop down list in macro

August 1, 2011 at 05:07:10
Specs: Windows XP
Hi Team,

I created Drop down list in Excel 2007.


If I select country in drop down list after in Area list it should display only the areas blongs to that particular country without selecting state and if I select Country and State in Area list it should appear the areas which belong to that particular state.

Please Help to resolve this issue.

Thank you.
K. Murugesan

See More: create drop down list in macro

Report •

August 1, 2011 at 10:18:39
There shouldn't be a need for a macro to accomplish your goal.

Review the information given at this site related to Dependent Data Validation Lists:

Note: The following will make more sense once you are familiar with the instructions found at that site.

You'll need to be creative with your Named Ranges.

For example, a Named Range of France would contain all of the areas in France.

A Named Range of FranceParis would contain the subset of the France areas located in Paris, France.

With your Country drop down in A1 and your State drop down in B1, the List source for the Area drop down would be =INDIRECT(A1&B1).

When B1 is blank, you'll get all the areas in the Named Range found in A1, e.g. France

When B1 contains a state, you'll get just those areas in the Named Range formed by A1&B1 e.g. FranceParis

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question