Search Google from a cell
Do you want to be able to type your search word in a cell, and then run a macro to search Google? This returns the results in a new Internet Explorer window
Search Google From a Cell
1. Put the following code in a module
Sub LaunchSite()
Dim newsite As Object
Set newsite = CreateObject("InternetExplorer.application")
newsite.Visible = True
newsite.Navigate _
"http://www.google.com/search?hl=en&ie=UTF-8&q=" _
& ActiveCell.Text
End Sub
2. Type your search word or phrase in a cell, hit enter, then click the cell again and run the macro!
Learn more about accessing Internet Explorer from VBA.
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!