Selecting worksheet dependent on columns drop down list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For starters: Please do not give me http://www.contextures.com/tiptech.html
and send me on my way. I have spent a great deal of time there and have no
come up with my answer.


I need to tell Excel that the item that I've chosen in Column C is the
worksheet I want it to go to for further instructions. I think if I can get
that, I can have multiple nested IF statements to do what else I need to do.
Is there a function that is meant to tell Excel that what is chosen from a
drop down list is the worksheet I want it to go to?

Thanks,
PC
 
Is there a function that is meant to tell Excel that what is chosen from a
drop down list is the worksheet I want it to go to?
Click to expand...

AFAIK, there's no such worksheet function ..

Suggest you try:
http://www.contextures.com/xlToolbar01.html
Navigation Toolbar for Workbook Sheets

where there's a sub by Dave Peterson
which produces the "droplist" functionality that you seek
Try the sample file on the page (link is there) ..

---
 
There's no function built into excel that allows this.

Well, you could use another cell and then an =hyperlink() formula and click on
that:

=IF(C1="","",HYPERLINK("#"&CELL("address",INDIRECT("'"&C1&"'!a1")),"ClickMe"))

This assumes that the worksheet name is in C1--I don't know how you made the
dropdown list.

Or you could use some sort of macro -- but you didn't share enough info to start
that.

=======
Alternatively, you could use a toolbar that is more generic. Instead of using a
worksheet cell as a navigation tool, you could use this from Debra Dagleish's
site (even if you don't want to visit there again!):

http://contextures.com/xlToolbar01.html
 
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("C:C")) Is Nothing Then Exit Sub
On Error GoTo endit
Application.EnableEvents = False
Select Case Target.Value
Case "1"
Sheets("Sheet1").Select
Case "2"
Sheets("Sheet2").Select
End Select
endit:
Application.EnableEvents = True
End Sub


Gord Dibben MS Excel MVP
 
Back
Top