Data Validation

[Destiney]

Is there a way when using a data validation list, to hyperlink the list
options to pages in the workbook? So for example, if you had a lot of
worksheets in one workbook, is there a way to choose a worksheet from the
list and have it go to the corresponding worksheet?


Thank you.

 

[Gary''s Student]

Say cell A1 has the data validation pull-down. Insert the following
worksheet code event:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub
Sheets(Target.Value).Activate
End Sub

After selecting a sheet name in cell A1, that sheet will automatically be
selected.

 

[Gord Dibben]

Yes, but there are other ways to select a sheet to go to.

Right-click on the navigation arrows at bottom left to get a list of 15 sheets
and "more sheets".

Rather than an dropdown list sheet with hyperlinks, try a sheet navigation
toolbar or similar.

Sheet navigation bar from by Dave Peterson at Debra Dalgleish's site.

http://www.contextures.on.ca/xlToolbar01.html

Or Bob Phillips' Browsesheets macro.

See this google search result.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP