Automate click "Select" button using vba

That post you copied your code from is at least 2 years old. The problem with writing code to interact with web sites is that the site can change.

It looks like Google has updated their approach to account management since that code was written. If you log into Gmail for the first time with no history, the screen first asks for an email address and has a Next button to move forward. There is no box to enter a password. Your code errors at that point but the code (unwisely) ignores the error and continues. Then you have to press a Next button to move to the next screen to enter your password.

Once you have logged in using this email address, the next time to login you will not see the first screen, and will be taken directly to the second screen.

This should all be evident to you as you F8 through your code while watching the Internet Explorer window at the same time.

Why not just submit the form?

Without seeing the rest of your code I can only guess but something like this might work.

Please Login or Register  to view this content.

Update: The code is working fine now after adding this:

Please Login or Register  to view this content.

Thank you.

Originally Posted by Norie

Why not just submit the form?

Without seeing the rest of your code I can only guess but something like this might work.

Please Login or Register  to view this content.

Hi Norie,

Thank you for the reply and apologize for the late reply. Was away to overseas.
I do not know how to submit the forms... would you be able to help me?
Below is my code:

Please Login or Register  to view this content.

Thank you!

HC