• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1000
  • Last Modified:

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?
1 Solution
Rory ArchibaldCommented:
Why not add a frame with a scroll bar and put all the controls you do want scrolled within that and leave the others outside it? Then you don't need to do anything yourself.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now