Adding Vertical and Horizontal Scrollbars in a userform using Userform_Activate method

[CakzPrimz]

Folks,

I have to add both vertical and horizontal scrollbars in a userform, so far I have this code below for horizontal scrollbars only.

Private Sub UserForm_Activate()
    With Me
    .ScrollBars = fmScrollBarsHorizontal
    .ScrollWidth = .InsideWidth * 1.5
    End With
End Sub

The second, how set the position of top scrollbar (vertical) and left scrollbar (horizontal) so it could like a freeze pane?

Thank you for your help and assistance

Best regards,
Prima

 

[Jaafar Tribak]

Folks,

I have to add both vertical and horizontal scrollbars in a userform, so far I have this code below for horizontal scrollbars only.

Private Sub UserForm_Activate()
    With Me
    .ScrollBars = fmScrollBarsHorizontal
    .ScrollWidth = .InsideWidth * 1.5
    End With
End Sub

The second, how set the position of top scrollbar (vertical) and left scrollbar (horizontal) so it could like a freeze pane?

Thank you for your help and assistance

Best regards,
Prima

If I understand correctly, you could place a scrollable frame control at the bottom half of the userform and place your buttons, textboxes etc inside the frame .. That way, you could keep the top half of the userform frozen when scrolling the controls thus imitating the freeze pane feature in excel.

 

[CakzPrimz]

Dear Jaafar Tribak,

Thanks for the solutions. It works !!!

Best Regards