ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hyperlinks (https://www.excelbanter.com/excel-programming/417055-hyperlinks.html)

KJ MAN[_2_]

Hyperlinks
 
Can a hyperlink in Excel reference a starting position on a list?

For example
Hyp[erlinks: A B C D ....... Z
Clicking on F will take the view and active cell to
the first cell in a column that has the letter F as the
1st character.

Thanks

dustinbrearton via OfficeKB.com

Hyperlinks
 
I would thinkg that would be easier to do with buttons. You could make a Sub
that would search like you are saying and then call that sub under the
on_click event.
KJ MAN wrote:
Can a hyperlink in Excel reference a starting position on a list?

For example
Hyp[erlinks: A B C D ....... Z
Clicking on F will take the view and active cell to
the first cell in a column that has the letter F as the
1st character.

Thanks


--
Message posted via http://www.officekb.com



All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com