Link Second drop-down list to a Worksheet

C

Compnerd

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
 
D

Debra Dalgleish

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Link Second drop-down list to a Worksheet 0
Link a text box based on drop down box with four options MS Word 365 0
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Drop down list - link to another worksheet 4
Drop Down Menu link to Pivot 0

Top