Hi,

I'm writing vba code in excel to navigate web pages in order to then extract
data from the web pages. I've had good luck so far with basic controls on
web pages. I can enter website login information and have figured out how to
select tabs, but now I have a listbox with filters for pages that I can't
get past. The listbox -- when you click on it normally with the mouse, up
pops a list of filters like "Last Day", "Last 7 Days", etc. as filters for
the specific data to display.

Thus far I've been using code like

Set ipf = ie.Document.all.Item("password")
ipf.Value = "(pword)"
Set ipf = ie.Document.all.Item("LoginForm")
ipf.Click

where ie = CreateObject or ShellWindows.Item to recognize the web page. So
far I've identified Document.all.Items by finding "name=" and "value=" and
"id=" in the html code. With the listbox, I've found the name of the Filter
Item and its options for values, but since it's not a form, I can't find out
how to activate the selected option. Any ideas what html code I should be
looking for?

Can anyone help?

Thanks,

Brian