How to Select a Value in an IE Drop List?

[kashford]

I have searched high and low for this, so I hope someone here can help.

I am trying to automate a repetitive process of changing information on an IE form from a list in Excel. My problem develops when I need to select a value from a drop down list. I can not get Excel to loop through the selections until it finds the matching data.

For example, if the spreadsheet contains MN, I need to loop through the state list until it stops on MN.

 

[michaelbr55]

Can you describe your problem more clearly, do you mean Internet Explorer for IE, where is your code?

Michael Bryant
Southern Ocean Software

http://southernoceansoftware.com