Activate Cell Hyperlink via Button?

[LewisHammy]

I have been working on a small project and have run into an issue activating the hyperlinks within my spreadsheet.

The hyperlinks are dynamic and depend on what has been added to the spreadsheet's text boxes. Because of this, I am unable to insert a static hyperlink into a button/ symbol.

ExcelForum Image1.PNG

To explain... The member first enters their UID into the text box, this then appears in cell C7. The link to our site is listed in cell C8, I merge both the link and UID in cell C9. In C10 I have a hyperlink formula which converts it to a clickable link.

Clicking the link itself works and takes me to the desired webpage but I have not figured out how to assign this dynamic hyperlink to the 'Go to UID' button.

Does anyone know how I can assign this hyperlink to the button or write some VBA so the button will click the link?

[mehmetcik]

Try

Please Login or Register  to view this content.

[LewisHammy]

Thanks for getting back to me!

That works perfectly! Thank you so much for helping, been driving me crazy all morning!

[LewisHammy]

Hi there

Just quickly going off the back of my initial question; how would I modify this code to activate a hyperlink on another sheet tab?

Thanks,
Lewis

[mehmetcik]

Please Login or Register  to view this content.

[LewisHammy]

It works perfectly!

Thanks again!