View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
John[_88_] John[_88_] is offline
external usenet poster
 
Posts: 205
Default Search Google from Textbox

Great. Thanks Harald, this works perfectly.

Thanks also Tom for Ron's email.

Best regards

John
"Harald Staff" wrote in message
...
Hi John

Private Sub CommandButton1_Click()
ActiveWorkbook.FollowHyperlink _
"http://www.google.com/search?hl=en&q=" & _
Replace$(Me.TextBox1.Text, " ", "+")
End Sub

Refine this coding by scrutinizing your manual Google searches' returning
url's, using quotes, domain restricted searches, ...

HTH. Best wishes Harald

"John" skrev i melding
...
Hi there,

I've got a user form which I'm using to check against a list of names.

What
I'd like to do is to assign a (Google) search to a command button, with

the
search words based on the text in a textbox.

Can anyone point me in the right direction?

(The button just needs to activate Internet Explorer with Google and the
search results.)

Thanks

John