Excel VBA 2007 - Userform scrollbar with frame focus issue

[chiuyian82]

Hi,
Im having problem in working the userform scrollbar.

I have created a userform with vertical scrollbar and added 2 frames to the userform.
My problem is for everytime i click any of the frame on the userform, the userform is being autoscroll to the frame top position.

How to stop the scrollbar from moving automatically on the event click on the frame?

Attached with the example.xlms.

Please help...

Thanks in advanced....

[Leith Ross]

Hello chiuyian82,

Your vertical scroll bar is part of the UserForm window. When an object is selected and the scroll bar is visible, the UserForm will automatically scroll to bring the object into view. To avoid this, you must place a ScrollBar object onto the UserForm and write the needed code to do what you want when it is moved.