Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link Second drop-down list to a Worksheet
I down loaded from the website www.contextures.com/xldataval02.html a zip
file called xld.dynamic_dropdowns_v1.2.xls. It had two drop list one for the Continent and second for the Country on Combo Example sheet. Is there code that when user click on the second list that it takes the user to a different worksheet in the same workbook? for example user choose Africa then Benin it would go to sheet2 or Europe then France it would go to sheet3 If there is code to work with file, can you gave a example. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link Second drop-down list to a Worksheet
That file isn't from my site, so I can't give any specific code
examples. How would you determine which sheet should be activated after a country is selected? Compnerd wrote: I down loaded from the website www.contextures.com/xldataval02.html a zip file called xld.dynamic_dropdowns_v1.2.xls. It had two drop list one for the Continent and second for the Country on Combo Example sheet. Is there code that when user click on the second list that it takes the user to a different worksheet in the same workbook? for example user choose Africa then Benin it would go to sheet2 or Europe then France it would go to sheet3 If there is code to work with file, can you gave a example. Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Link drop-down list? | Excel Discussion (Misc queries) | |||
To Link drop-down list | Excel Discussion (Misc queries) | |||
How do I link 2 drop down list together? | Excel Discussion (Misc queries) | |||
Link from a drop down list | Excel Worksheet Functions | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) |