Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drop down menu with validation that requires Marco
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drop down menu with validation that requires Marco
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 "ssi141" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Drop Down Menu Width | Excel Discussion (Misc queries) | |||
Drop down menu and validation over mulitiple sheets | Excel Worksheet Functions | |||
The drop down menu of my validation list needs to display more. | Excel Discussion (Misc queries) | |||
Validation- Drop Down menu size | Excel Discussion (Misc queries) | |||
How do I set up a drop down menu for a validation list? | Excel Worksheet Functions |