+ Reply to Thread
Results 1 to 5 of 5

Creating Hyperlink to a variable sheet name

  1. #1
    Forum Contributor
    Join Date
    04-20-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    118

    Creating Hyperlink to a variable sheet name

    Hello i've been stuck in here, hope u can help me.

    I have a code that copy's the last sheet and remane it to any value that is on the textbox.

    At the same time i wanted to create a hyperlink on another sheet that connects to the fresh created sheet.

    So far i got this:
    Please Login or Register  to view this content.
    The line at red is where i'm stuck in, Can't figure it out
    Last edited by Tpleme; 11-23-2017 at 08:43 AM.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,914

    Re: Creating Hyperlink to a variable sheet name

    What value is in the variable FName ?

  3. #3
    Forum Contributor
    Join Date
    04-20-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    118

    Re: Creating Hyperlink to a variable sheet name

    its text.

    textbox1 contains a person full name, and Fname separates the name to show only the first and the last name.

    The name of the sheet that is created is the person's first and last name (FName).

  4. #4
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,914

    Re: Creating Hyperlink to a variable sheet name

    e.g.:
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    04-20-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    118

    Re: Creating Hyperlink to a variable sheet name

    thank you, really apreciate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Creating Hyperlink to new sheet
    By rigby in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2013, 02:10 AM
  2. [SOLVED] Creating a variable price sheet
    By KayF in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-27-2013, 10:07 AM
  3. [SOLVED] creating a variable range in VBA to be copied to variable sheets
    By adamNBU in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-29-2013, 06:20 PM
  4. Need help creating a formula/sheet with a fixed variable
    By RemanBill in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-24-2013, 03:29 PM
  5. hyperlink to a sheet with a name defined by a variable
    By crickertsen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-07-2012, 06:48 PM
  6. Hyperlink to a Variable Sheet name
    By Gecks in forum Excel General
    Replies: 0
    Last Post: 02-13-2012, 05:58 PM
  7. VLookup - creating a variable Sheet reference?
    By futbol1097 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2007, 01:57 PM
  8. [SOLVED] Creating Variable for a Sheet
    By kyle in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-30-2006, 11:40 AM

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