VBA to select button then pull down selection on next page

[steve216586]

Basically I have built an Excel to open an IE page. Now I need to select a button which takes me to another page. There I need to select an item from a pull down and then select the button to submit.

I'm sure this is easy for pros but I'm just getting started and would appreciate any help. I can find the names of the buttons and pull down item. I just don't know how to orderly call them in code so the sequence is complete.

 

[steve216586]

I found out how to navigate to the page I need so forget about the first part. I also found out how to "tap" a select button. Now I am in need of code to select an item from a drop down. Then I can use my code for "tapping" the select button. Any heop wol dbe appreciated.

This is what I have so far:

Private Sub cmdLoadURLs_Click()
Dim IE As Object
Dim shellWins As New ShellWindows
Dim IE_TabURL As String
Dim intRowPosition As Integer

intRowPosition = 2

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

IE.Navigate Sheet1.Range("A" & intRowPosition)

While IE.Busy
DoEvents
Wend

intRowPosition = intRowPosition + 1

While Sheet1.Range("A" & intRowPosition) <> vbNullString
IE.Navigate Sheet1.Range("A" & intRowPosition), CLng(2048)

While IE.Busy
DoEvents
Wend

intRowPosition = intRowPosition + 1
Wend

Set IE = Nothing
End Sub

For Each btnInput In ElementCol
If btnInput.Value = "Submit" Then
btnInput.Click
Exit For
End If
Next btnInput