User worked 'jump to'?

[dantheram]

Can someone please help em to create a function where the user of my workbook can click on a section number and then the sheet automatically 'jumps' to that section?

So, column A has the following

1.1
1.2
1.3
1.4
etc
etc

My tool should simple have a list of column A and when the user chooses a section the sheet jumps to it.

Is this possible?

Many thanks,

Dan

 

[Andrew Poulsom]

Can't you use Hyperlinks (Insert|Hyperlink)? The displayed text can be different from the actual link reference.

 

[doofusboy]

Something like this should work [of course you would have to customize for your needs]:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Select Case Target.Value
        Case "1.1"
            Range("B1").Select
        Case "1.2"
            Range("C1").Select
        Case "1.3"
            Range("D1").Select
        Case "1.4"
            Range("E1").Select
    End Select
End Sub

 

[hatman]

I would recommend using the Hyperlink() function. To umop to cell A10 of teh current sheet, use:

 =HYPERLINK("#a10","link")

or to jump to that cell on shet 2 use

=HYPERLINK("#sheet2!a10","link")

 

[hatman]

Can't you use Hyperlinks (Insert|Hyperlink)? The displayed text can be different from the actual link reference.

The trick to this is the use of the pound sign (#) to indicate to Excel that it's a hyperlink locally within this workbook, and not a URL or a file location.

 

[Andrew Poulsom]

The trick to this is the use of the pound sign (#) to indicate to Excel that it's a hyperlink locally within this workbook, and not a URL or a file location.

I'm aware of that, but I don't see the relevance to what I posted.

 

[hatman]

I would recommend using the Hyperlink() function. To umop to cell A10 of teh current sheet, use:

 =HYPERLINK("#a10","link")

or to jump to that cell on shet 2 use

=HYPERLINK("#sheet2!a10","link")

The one major benefit of using teh Yperlink() function versus an embedded Hyperlink Object is that as a function, you can perform calculations. Here is an example of a formula that will automatically update to teh proper location as rows or columns are added or deleted in teh worksheet:

=HYPERLINK("#"&CELL("address",A21),"link")

 

[hatman]

I'm aware of that, but I don't see the relevance to what I posted.

I figured you did. And I didn;t mean to imply differently. I was simply offering some additional info to the OP. Maybe I'm wrong, but from your own post, it didn;t seem clear to me that anything special would be needed to make it work...

 

[dantheram]

But if i have a hyperlink to each one i need a great long list of sections, is there anyway i can get the sections in a drop down?

 

[Andrew Poulsom]

I figured you did. And I didn;t mean to imply differently. I was simply offering some additional info to the OP. Maybe I'm wrong, but from your own post, it didn;t seem clear to me that anything special would be needed to make it work...

Nothing special is required with Insert|Hyperlink, which I suggested. You merely select 'Place in this document' and fill in the boxes. But I agree that the HYPERLINK function provides more flexibility.