If A2 =X from list V then B2= Y from list W

[AERIF]

I need help with this situation.
lets stay column A has drop down menu where I can select 5 countries, depending on what country I select in A I want the corresponding cell in column B to allow me to select only from a list of cities of the country selected in A.

Thank you
[email protected]

[Leith Ross]

Hello Aerif,

This code uses a Drop Down box that holds the names of the countries and List Box that will display the cities. Selecting a country loads the List Box with the cities you want.

You need to set the Drop Down list's macro to SelectCountry to make it work. I was uncertain if you wanted to return the city that was selected to a particular cell. Let me know and I can change that for you.

Copy and paste this code into the declarations section of the Worksheet the Drop Down list and List Box are on. You need to change the numbers of the Drop Down and List Box to match those on your worksheet. They are marked in red. Also the you will need to change the cities list. You can add as many country/city combinations as you need. Just follow the format as it is shown.

Please Login or Register  to view this content.

[Toppers]

Hi,
Look at the following which explains how to create dependent Data
Validation lists.

www.contextures.com/xlDataVal02.html

HTH

"AERIF" wrote:

>
> I need help with this situation.
> lets stay column A has drop down menu where I can select 5 countries,
> depending on what country I select in A I want the corresponding cell
> in column B to allow me to select only from a list of cities of the
> country selected in A.
>
> Thank you
> [email protected]
>
>
> --
> AERIF
> ------------------------------------------------------------------------
> AERIF's Profile: http://www.excelforum.com/member.php...o&userid=28395
> View this thread: http://www.excelforum.com/showthread...hreadid=479867
>
>