Selecting worksheet dependent on columns drop down list
 

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

Selecting worksheet dependent on columns drop down list
 

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?

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) ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Selecting worksheet dependent on columns drop down list
 

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



PCoyne wrote:

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

--

Dave Peterson

Selecting worksheet dependent on columns drop down list
 

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

On Tue, 3 Jul 2007 07:20:00 -0700, PCoyne
wrote:

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