+ Reply to Thread
Results 1 to 3 of 3

Hyperlink using a button to another sheet in the workbook

  1. #1
    Forum Contributor
    Join Date
    02-27-2007
    Posts
    156

    Hyperlink using a button to another sheet in the workbook

    I want to put a generic script/macro onto a button that would look at the value of cell A1 and then move to the Worsheet called "Sheet" + A1 in my current workbook.

    How could I do that???

    For example A1 contains the value 15. When I click on my button I want it to take me to Sheet15 in the current workbook. If I click on a different button I want it to take me to the Worsheet Info15 in the workbook...

    The key is concatenating the word Sheet or Info or whatever with the value that is found in A1 and then Hyperlinking to that worksheet.

    Anyone got ideas?

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Hi bmasella,

    If you add the following code to your commandbutton's click event it should do what you're asking:
    Please Login or Register  to view this content.
    The error handling is used in case the value in cell A1 doesn't correspond to an actual sheet in your workbook.

  3. #3
    Forum Contributor
    Join Date
    02-27-2007
    Posts
    156

    Perfect!!!

    Thanks so much... it works PERFECTLY!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1