greep
asked on
Excel User Form Scroll Bar - Click Event?
I have a very tall User Form to which I have added a vertical scroll bat to let the user navigate up and down. On this form I have a frame containing some controls that I always wish to have in view. So I need to move them proportionately to the Form's scroll event
I have added code to the UserForm_Scroll event like this
lblValidateApplication.Top = Me.ScrollTop + 66
This works fine if the user drags the scroll bar, or clicks on the up/down arrows.
But not if the user clicks directly on the bar's background This has the effect of scrolling to the clicked position but does not seem to trigger the Scroll event. Is there a way I can capture this event?
I have added code to the UserForm_Scroll event like this
lblValidateApplication.Top
This works fine if the user drags the scroll bar, or clicks on the up/down arrows.
But not if the user clicks directly on the bar's background This has the effect of scrolling to the clicked position but does not seem to trigger the Scroll event. Is there a way I can capture this event?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.