Dynamic hyperlink tied to a button in Excel

[mikeolson]

I want a concat'd hyperlink tied to a button, that when clicked, goes to a website, which would be the dynamic input of what the user entered into a cell added to the end of a static website address I have in another cell. I'm using this function to search a website that puts the user input at the end of a search url. Can someone help me? I know how to make automatic hyperlinks between two cells with if and concat and the hyperlink function. I just don't know how to attach them to a button, and make it so the user input dictates the url that's visited when the button is clicked.

 

[kennypete]

Create the button in Developer, assign a macro to it:

Working example, concatenating the fixed https and a variable, in this case, search text to add to a google search:

Sub Button1_Click()
    ThisWorkbook.FollowHyperlink (Cells(1, 2).Value & Cells(2, 2).Value)
End Sub

In action:

 

[mikeolson]

Thank you. It worked like a charm!