Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
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. -- Gary''s Student - gsnu200771 "Destiney" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
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 On Mon, 3 Mar 2008 17:22:06 -0800, Destiney wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |