Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink based on user's input
I have a workbook with several worksheets. Is it possible to jum (hyperlink) to a specific worksheet by entering its name in a cell? For example, i have a workbook with worksheets A,B,C,D,E. If the user enters "D" i a specific cell, I'd like that worksheet to open. Does that make sense -- izbryt ----------------------------------------------------------------------- izbryte's Profile: http://www.excelforum.com/member.php...fo&userid=1674 View this thread: http://www.excelforum.com/showthread.php?threadid=32011 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink based on user's input
go to tools-macro-visual basic editor. double click sheet1 ,sheet .... and paste the below code. Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo interrupt Worksheets(Target.Value).Select interrupt: End Su -- anilsolipura ----------------------------------------------------------------------- anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627 View this thread: http://www.excelforum.com/showthread.php?threadid=32011 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink based on user's input
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany "izbryte" schrieb im Newsbeitrag ... I have a workbook with several worksheets. Is it possible to jump (hyperlink) to a specific worksheet by entering its name in a cell? For example, i have a workbook with worksheets A,B,C,D,E. If the user enters "D" in a specific cell, I'd like that worksheet to open. Does that make sense? -- izbryte --------------------------------------------------------------------- --- izbryte's Profile: http://www.excelforum.com/member.php...o&userid=16740 View this thread: http://www.excelforum.com/showthread...hreadid=320110 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
run macro with input msg based on cell input | Excel Discussion (Misc queries) | |||
copy worksheet multiple times base on user's input | Excel Worksheet Functions | |||
hyperlink based on user's input | Excel Worksheet Functions | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |