Scroll Event
 

Is there an Event for Scrolling in a Worksheet. I need to have a section of
the sheet change formats when it is scrolled left or right.

Scroll Event
 

Hello JeremyJ,

Excel doesn't expose the scroll event in VBA. It might be possible
using more advanced techniques, like Sub-Classing, to intercept the
event.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45354

Scroll Event
 

I am interested. How does Sub-Classing work?

"Leith Ross" wrote:


Hello JeremyJ,

Excel doesn't expose the scroll event in VBA. It might be possible
using more advanced techniques, like Sub-Classing, to intercept the
event.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45354