title: VBA: How to get page to update after filling in the select box
body: <p>I'm trying to use the full matchup table on this page <a href="https://stats.nba.com/player/2544/head-to-head/?Season=2018-19&amp;SeasonType=Regular%20Season" rel="nofollow noreferrer">https://stats.nba.com/player/2544/head-to-head/?Season=2018-19&amp;SeasonType=Regular%20Season</a>
  So far this is what I have:</p>
  
  <pre><code>Option Explicit
  Sub BrowsetoSite()
  
  Dim IE As Object
  
  Set IE = CreateObject("InternetExplorer.Application")
  
  IE.Visible = True
  IE.navigate "https://stats.nba.com/player/2544/head-to-head/?Season=2018-19&amp;SeasonType=Regular%20Season"
  
  
  Do While IE.ReadyState &lt;&gt; READYSTATE_COMPLETE
  Loop
  
  
  IE.Document.getElementsByClassName("stats-table-pagination__select")(0).Value = "string:All"
  On Error Resume Next
  IE.Document.getElementsByClassName("stats-table-pagination__select")(0).Focus.FireEvent ("onchange")
  
  
  End Sub
  </code></pre>
  
  <p>That fills in the page selection as "All", but the page does not upload like it does if you were to click that option on the website. How do I fix this? </p>
  
  <p>Here is the HTML code for the selection:</p>
  
  <pre><code>&lt;select class="stats-table-pagination__select ng-valid ng-not-empty ng-touched ng-dirty ng-valid-parse" ng-model="vm.data.page" ng-options="p for p in vm.data.pages" aria-invalid="false"&gt;
  &lt;option label="All" value="string:All"&gt;All&lt;/option&gt;
  &lt;option label="1" value="number:1" selected="selected"&gt;1&lt;/option&gt;
  &lt;option label="2" value="number:2"&gt;2&lt;/option&gt;
  &lt;option label="3" value="number:3"&gt;3&lt;/option&gt;
  &lt;option label="4" value="number:4"&gt;4&lt;/option&gt;
  &lt;option label="5" value="number:5"&gt;5&lt;/option&gt;
  &lt;option label="6" value="number:6"&gt;6&lt;/option&gt;
  &lt;option label="7" value="number:7"&gt;7&lt;/option&gt;
  &lt;/select&gt;
  </code></pre>