I have a form controls scrollbar in my worksheet. I would like to run code not only when the arrows of the scrollbar are clicked but also as the bar is being scrolled without letting up on the mouse button.
When the bar is left-clicked and slid, I can see that the linked cell is changing, but my change scroll bar code (below) is not running:
It only runs when you let go of the left mouse button (or single click one of the end arrows). I thought this worksheet change event code would work because the range "myrange" does change as the bar slides.Please Login or Register to view this content.
But, apparently ranges changed by the scrollbar do not qualify as worksheet changes.Please Login or Register to view this content.
Anyone see a way to get code to run as the linked cell value of the scrollbar changes?
thanks
Bookmarks