title: Detecting Excel scroll in VBA
body: <p>I read <a href="http://www.cpearson.com/excel/DetectScroll.htm" rel="nofollow noreferrer">this</a> by Mr Pearson saying that the excel object model doesn't allow detecting when the user scrolls and that in order to do so, we'll need to install some third party dlls, etc...</p>
  
  <p>Is this still true in Excel 2010? The macro recorder seems to detect scrolling and prints the scrolling location to the subroutine as you scroll around the sheet (in fact you can see it doing this in real-time if you have the module visible while you scroll)... Surely there must be a way to do this if the macro recorder is doing it without installing other dlls?</p>
  
  <p>Example code generated by macro recorder:</p>
  
  <pre><code>ActiveWindow.ScrollRow = 16
  ActiveWindow.ScrollRow = 17
  ActiveWindow.ScrollRow = 18
  ActiveWindow.ScrollRow = 19
  </code></pre>