(Solved) – How to send Tab button key press event 10 times and increment it by 1 in a loop using VBA


Is there a way where I can send a TAB key press event 10 times using the command (Application.SendKeys “{TAB 90}) and then programmetically increment the count by 1 such that it sends (Application.SendKeys “{DOWN 91}) .

I have a drop down list on a web page where I need to select an item, press a search button ,then scraps items from the resulting searched page and finally going back to the main search page to again select the next item in the drop down list to repeat the above process. The drop down list contain 300 items. The drop down list do

I know there might be a better way to do this. Please enlighten me.

Below the HTML snippet from the web page for the button