View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daphne
 
Posts: n/a
Default Selection of Drop down list that allows you to go to a particular cell

Hi all,

I need help to do the following thing:

1. Have a drop down list (e.g. Scenario 1, Scenario 2, Scenario 3)
2. When user select (e.g. Scenario 2) from the drop down list and click
on a "Go" Button, it will take the user to the cell that says Scenario
2.
3. There will only be one Scenario 2 in the whole sheet.

Thanks a lot.