Hyperlink to update cell value in another sheet (same workbook) using excel VBA

  • Hi all,

    Could you please help me to include a command to a hyperlink. I want to update a cell value in another sheet when hyperlink is clicked. I have the code for hyperlink directing to website (mentioned below). Is there a way to modify this code so that when hyperlink is clicked, a cell value in another sheet is updated.

    Code I have:

    ActiveSheet.Hyperlinks.Add Range("E2"), Address:="https://www.automateexcel.com/", TextToDisplay:="Issue", ScreenTip:="Issue Stationary to Request Owner"

  • Please read the Forum Rules and don't ask the same question twice. I have already told you that you cannot use hyperlinks this way.

  • royUK

    Closed the thread.