Adding Vertical and Horizontal Scrollbars in a userform using Userform_Activate method

[Prima Satria]

Dear Chandoo,

I have to add both vertical and horizontal scrollbars in a userform, so far I have this code below for horizontal scrollbars only. The question 1, how to make a vertical scrollbar in the same userform?

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

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

Thank you

 

[NARAYANK991]

Hi ,

It would make it easier for members to help you , if you could upload your workbook which has the userform and the scrollbar(s) and the code in it.

Narayan