VBA for Morningstar Search Button

Hi guys,

I am trying to get use a macro to go to the webpage of a stock that gets entered into the search bar of morningstar. I found a useful youtube video that showed me the code that allows you to open up internet explorer and enter in the name of the stock into an input box, which will then enter it automatically into the search bar of the webpage, but that is as far as I have gotten. I got it to work up to that point, but am stuck on the part to get it to click search to load up the page.


Can someone help me?

Need to show us your code so far.

Sub clickformbutton()
Dim ie As Object
Dim form As Variant, button As Variant


Set ie = CreateObject("internetexplorer.application")

mystock = InputBox("enter stock name, eg. pepsico inc, coca-cola co")

With ie

.Visible = True
.navigate ("website url here")

While ie.readystate <> 4
DoEvents
Wend

ie.document.getelementsbyclassname("mdc-site-search__form").Item.innertext = mystock

Set frm = ie.document.forms("f")
Set srch = frm.document.all("q")
srch.Value = Rng
frm.submit

End With

Set ie = Nothing

End Sub