The scroll bar is linked to a cell, so my first tries to get it to trigger the macro have been using
to check for a change in the linked cell. But this doesn't seem to trigger the macro. (The code above works perfectly in a simple worksheet with no ActiveX control, where I simply type a value into the target cell and press enter.)![]()
Please Login or Register to view this content.
Can anyone suggest a way to detect a change in the ActiveX control which I can use to trigger the macro?
Thanks for advice
Bookmarks