vba google search on chrome from excel

mbasith · #1 10-25-2018, 06:16 AM

Hello friends,

I have macro which opens IE but unable to search for the keyword of the cell C3, i need modification that, instead of IE, it need to open chrome browser
when combo keys eg:. CTRL+SHIFT+E --

macro should go that particular cell say C3 and would pickup that keyword search directly in chrome to show the possible result

Appreciate your help in this regard,

Thanks,

Code:

Sub Macro1()
'
' Macro1 Macro
' chrome google search
'
'Keyboard Shortcut: Ctrl Shift + E
 Dim s As String
Dim IE As Object
Range("C3").Select
ActiveCell.FormulaR1C1 = " "
Range("C3").Select
s = Selection.Copy
's = InputBox("Enter ur search key", "Key")
Set IE = CreateObject("InternetExplorer.application")
IE.Navigate "https://www.google.co.in/search?q=" & s
IE.Visible = True
While IE.busy
DoEvents
Wend
Set IE = Nothing
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Update Excel worksheet from Google sheet	tasneemj	Excel	0	02-11-2018 12:17 PM
Error in exporting Google Sheet to Excel	cmcmeekin	Excel	2	08-03-2016 11:32 AM
=filter() feature of google sheets not in EXCEL	peter.threepins	Excel	1	07-13-2016 08:44 AM
Adding Google Search to Words right click menu	TVTime	Word	1	01-08-2015 11:53 PM
Adding a google search to Word	alexb123	Word	0	03-23-2011 04:30 PM