View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Compnerd Compnerd is offline
external usenet poster
 
Posts: 9
Default 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