Haarish,

There is no event that is triggered when you scroll in a window. You can use
a technique called "subclassing" to detect the Windows messages sent during
scrolling.  VBA doesn't have the performance horsepower to do the actual
subclassing itself, so I use a free DLL from vbAccellerator,
www.vbaccellerator.com, called SSubTimer6.dll. Once you have that DLL on
your machine, you can use the class module on my web site to detect
scrolling. The class will raise normal VBA events for scrolling up/down
left/right by page/line.

See http://www.cpearson.cm/Excel/DetectScroll.htm details and downloadable
example workbook.