How to Change Drop Down value on a website through Excel VBA

[spriyatam]

Hi,

I have coded a macro through which I can login to a website automatically (login ID & Pswrd accepts automatically as it's the part of code). Then it selects few options on the page. There's a drop down menu where I need to select "NWC CHAT". However, I am not sure what should be the parameter to be used for it.

For Example, the below code is working as it does select the date as per my code:

HTMLDoc.all.StartDate.Value = "9/1/2014"

Below is the HTML source code specifically for that portion where the drop down menu is:

I will really appreciate if someone can help me on this.

Best Regards,

Shaurya

[spriyatam]

Looking ahead for your valuable suggestion to fix my issue.

Best Regards,
Shaurya.

[Leith Ross]

Hello spriyatam,

Here is an example of how to choose an Option in a Select box. You will need to adapt and integrate this code with your own.

Please Login or Register  to view this content.