+ Reply to Thread
Results 1 to 7 of 7

Need formula to set value when hyperlink is clicked

  1. #1
    Registered User
    Join Date
    05-19-2014
    Posts
    35

    Need formula to set value when hyperlink is clicked

    I need a foruma to set value when hyperlink is clicked in excel

    This is my formula =HYPERLINK("#Sheet2!A1",A8) I need to set value (any dummy value) in sheet2 A1
    Last edited by vinod2802; 12-03-2019 at 04:56 AM.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Need formula to set value when hyperlink is clicked

    That's not the greatest explanation. How should anyone what you actually need with so few details? Provide a proper explanation and if needed a sample. Check the yellow banner above.
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    05-19-2014
    Posts
    35

    Re: Need formula to set value when hyperlink is clicked

    This is my formula =HYPERLINK("#Sheet2!A1",A8) I need to set value (any dummy value) in sheet2 A1

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: Need formula to set value when hyperlink is clicked

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

  5. #5
    Registered User
    Join Date
    05-19-2014
    Posts
    35

    Re: Need formula to set value when hyperlink is clicked

    excel version is 2013

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: Need formula to set value when hyperlink is clicked

    It would help for the future if you updated your profile as requested. Thanks

  7. #7
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Need formula to set value when hyperlink is clicked

    withdraw missed something

+ 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. Detect whether hyperlink formula was clicked/followed
    By LeanAccountant in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-22-2014, 12:31 PM
  2. Add 7 days from today when Hyperlink is clicked
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2013, 04:03 PM
  3. [SOLVED] Log What Hyperlink is Clicked in External TXT File
    By miked79 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-20-2012, 04:10 AM
  4. Which hyperlink was clicked and associated shape name
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-22-2010, 05:30 PM
  5. Extracting a row number from where a hyperlink was clicked
    By ggabs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2009, 06:24 AM
  6. Invoke macro instead of hyperlink that was clicked
    By ohadm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2009, 03:45 PM
  7. Insert Data when hyperlink is clicked
    By Chuck N in forum Excel General
    Replies: 2
    Last Post: 09-09-2005, 12:12 PM
  8. Help! How to record time a hyperlink was clicked?
    By yoggit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2005, 11:17 PM

Tags for this Thread

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