Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Excel 2003: Clicking on a LINK that takes you to a different cell in the Workbook
Is there a simple way to code a link on an Excel workbook so that when
you click on it, it takes you to a specific cell in the workbook? For example. At the top of the spreadsheet you have a number of parts: Part #1 Part #2 Part #3 I can easily make them links -- but what is the code that I need so when I click on Part #2 it takes be to a cell on the workbook (e.g., Cell A1827) where the user finds related information about it? Thanks for any assistance with this! RBollinger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Excel 2003: Clicking on a LINK that takes you to a diffe
Forgive me but I took the liberty of modifying your request just a tad.
Insead of on selecting a cell, the user needs to double click the cell. From experience I know that users find the on select to be frustrating. Here is the code for the double click. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True Select Case Target.Address Case "$B$1" With Sheets("Sheet2") .Select .Range("A50").Select End With Case "$B$2" With Sheets("Sheet3") .Select .Range("A20").Select End With End Select End Sub Right click on the tab of the sheet that you want to react to the doubleclick. Select View Code and paste the above into the code window... HTH "robboll" wrote: Is there a simple way to code a link on an Excel workbook so that when you click on it, it takes you to a specific cell in the workbook? For example. At the top of the spreadsheet you have a number of parts: Part #1 Part #2 Part #3 I can easily make them links -- but what is the code that I need so when I click on Part #2 it takes be to a cell on the workbook (e.g., Cell A1827) where the user finds related information about it? Thanks for any assistance with this! RBollinger |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Excel 2003: Clicking on a LINK that takes you to a different cell in the Workbook
If their value is produced by a linking formula linked to the source data,
you can go into tools=options, edit mode and unselect Edit directly in a cell. Then if you double click on the cell, you will be taken to the cell it is linked to. No coding required. Editing is then done in the formula bar. -- Regards, Tom Ogilvy "robboll" wrote in message ups.com... Is there a simple way to code a link on an Excel workbook so that when you click on it, it takes you to a specific cell in the workbook? For example. At the top of the spreadsheet you have a number of parts: Part #1 Part #2 Part #3 I can easily make them links -- but what is the code that I need so when I click on Part #2 it takes be to a cell on the workbook (e.g., Cell A1827) where the user finds related information about it? Thanks for any assistance with this! RBollinger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link cell in to different worksheets in same workbook excel 2003 | Excel Discussion (Misc queries) | |||
Opening files by double clicking takes for ever - Word, Excel | Setting up and Configuration of Excel | |||
hyperlink - clicking on hyper link to select cell in another sheet | Excel Worksheet Functions | |||
Double Clicking on link w/i workbook does't bring me to souce. | Excel Worksheet Functions | |||
Double-clicking cell with =A1 no longer takes you to A1 in v2003? | Excel Discussion (Misc queries) |