Google search of text in cell by clicking on that cell

How do I make a search so the user can click on cell A2 and it does a Google search for that text plus the text in the cell B2 next to it?

Try this in the worksheet module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Count = 1 Then
        If Not Intersect(Target, Range("A:A")) Is Nothing Then
             If Target.Row > 1 Then
                If Target <> "" And Target.Offset(, 1) <> "" Then
                    ThisWorkbook.FollowHyperlink Address:="https://www.google.com/search?q=" & Target.Value & "+" & Target.Offset(0, 1).Value
                End If
            End If
        End If
    End If
End Sub

BSB

@AliGW - Apologies, I hadn't refreshed the screen and seen your message above before posting.

BSB

I was hoping to do it without VBA but this will work. thanks guys!

A VBA free option would be to put hyperlinks in another column and use that to click on rather than column A.

For example, the below in C2 and copied down.

Formula:

=HYPERLINK("https://www.google.com/search?q="&A2&"="&B2)

This comes with the added maintenance of having to apply the formula to new rows of data, whereas the VBA option would account for that automatically.

There are probably other ways, but that's two options for ya.

BSB