Sub automaticformfilling()
Dim IE As Object
Set IE = CreateObject("internetexplorer.application")
With IE
.Visible = True
.Navigate "http://google.de"
Do While .busy
DoEvents
Loop
Do While .ReadyState 4
DoEvents
Loop
Set searchtext = .document.getelementbyid("lst-ib")
searchtext.Value = ThisWorkbook.Sheets(1).Range("A1")
.document.forms(0).submit
Do While .busy
DoEvents
Loop
Do While .ReadyState 4
DoEvents
Loop
Set searchres = .document.getelementbyid("resultStats")
ThisWorkbook.Sheets(1).Range("B1") = searchres.innertext
.Quit
End With
End Sub