IE automation -- select item from list

[leaftye]

How do I select "AZ" from the list this code would generate:

<select name="delstate" size="1" tabindex="8">
  <option >CA</option>
  <option  >AZ</option>
  <option  >NV</option>
  <option  >OR</option>
  <option  >WA</option>
</select>

I'm wishing this to work without luck:

Set IEapp = CreateObject("InternetExplorer.Application")
IEapp.Document.all.Item("delstate").Value = "AZ"

I could use SendKeys, but would rather not.

Eugene

 

[Legacy 98055]

The options collection of the HTMLSelectElement is zero based. Therefore, the index of 1 is actually the second option. To select the second option, "AZ", use this code:

ieapp.document.all.Item("delstate").selectedIndex = 1

Tom

 

[leaftye]

Thanks Tom, I'll give that a shot when I get to the office!

 

[leaftye]

Worked great, thanks Tom!