How to change Select Tag Option Value using VBA?

headhair

New Member
Joined
Nov 8, 2010
Messages
15
I am writing an Excel VBA code to fetch data from website.


The displayed data is paginated and select option is given to display the number of records




HTML:
<select class="ui-paginator-rpp-options ui-widget ui-state-default ui-corner-left" value="20">
<option value="20" selected="selected">20</option><option value="50">50</option><option value="100">100</option></select>
There are more than 500 records. I want to display all data in one page so as grab them easily.
For that I need to change one of the above values from
HTML:
<option value="100">100</option>
to
HTML:
<option value="800">100</option>
and fire selection.


Is it possible change option value of select tag once the page is loaded using excel VBA?


Help needed.
 
Last edited:

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
can you do that manually in the query bar, not many sites allow an over select?
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
i appreciate you want to automate a manual task, i'm just suggesting that it may not work, if you can do it manually then it should be possible
 

Watch MrExcel Video

Forum statistics

Threads
1,122,734
Messages
5,597,807
Members
414,177
Latest member
RezaAkhund

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top