Manipulating Dropdown List in IE using VBA & Form Submit oddities

Where's the rest of the code?

Here is the rest of the code for the first. Getting the second code in a minute. It's kinda sloppy but I've had to make do with a semi-automatic version that required some manual input. My client wants it fully automated though!

Please Login or Register  to view this content.

Edit: I'm super sorry but the select case part that defined Ave is missing in some code somewhere. Trust me, there is a definition for it. The variables themselves are fine (at least they are defined) but they won't input into the forms. I know my code is an absolute mess but I have been toying with it for hours and I just cannot get these dumb forms to accept ANYTHING!

Edit #2: Found the avenue piece. I will update with code 2 in a minute.

Here is the full second problem code:

Please Login or Register  to view this content.

Hopefully this helps. Again I apologize, I've been hacking at this code way too much to make it work but I've tried everything I can think of and some google searches. If you can help I would be so thankful!!!!

Edit: Cleaned it up some. Let me know if I can do anything else to help!

This is how you can select from the Suffix dropdown.

Please Login or Register  to view this content.

I'm sorry but that code doesn't compile.

Originally Posted by Norie

This is how you can select from the Suffix dropdown.

Please Login or Register  to view this content.

Fantastic! That worked perfectly! Thank you so much!

Edit: I'll clean up the second code so it compiles. I needed to make it actually look halfway decent anyway.

Edit #2: Here is the code. I accidentally deleted a next i.

Please Login or Register  to view this content.

Thanks for your patience!