Button with link url based on cell

[mrjebennett]

Hello. I am trying to figure out a way to have a single button send the user to google based on the content of a cell.

For example. If F1 has JANE DOE... then once the button is pushed it would send the user to google and JANE DOE would already be in the search.

I would think a simple google string as such (https://www.google.com/search?q=jane+doe) would suffice. Is this possible?


Thanks!

 

[daverunt]

Hi,

Here's one method with very basic code.

This relies on the user selecting the cell with the search term/name in then pressing the button to which this macro is assigned.

Sub Make_hyperlink()


bLink = "https://www.google.com/search?q="
uLink = ActiveCell.Value

hLink = bLink & uLink


ThisWorkbook.FollowHyperlink (hLink)

End Sub