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"

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!