Drop down menu with validation that requires Marco

[ssi141]

I try to create a form that contain two cells where cell 1 requires user to
enter information like A or B or C. I am able to use drop down method for
cell 1.
However, the cell 2 require certain validation that relate to information
that entered in cell 1. if User enter A in cell 1, then only the require
information like A1, A2, & A3 shall appear in the drop down menu, likewise if
user enters B or C.

I have little knowledge on Excel, and only get to undertand the drop down
method after asking around. I try to follow the online help on creating the
Macro but fail to understand.

Need your help. Thanks

 

[Shane Devenshire]

Hi,

Here are the steps for creating a dynamic data validation list:

1. Create three or more list in the spreadsheet. For example:
A B C
New York Quebec Canada
Seattle Toronto US
Miami Victoria

You would name lists: US (A1:A3), Canada (B1:B3), Countries (C1:C2) this
last is optional

2. Select the cell where you want the initial validation list, for this
example, D1
3. Choose Data, Validation
4. From the Allow drop-down and choose List
5. In the Source box enter the following formula
=Countries
6. Move to the location where you want the dynamic (changing) list to
appear, say for example E1
7. Choose Data, Validation, List and in the Source box enter the formula
=INDIRECT(D1)

You can also make a self-referential dynamic data validation list.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire