Announcement

Collapse
No announcement yet.

Scrollbars On Userform

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Scrollbars On Userform



    I have a userform (Height=500) very long. How active a scrollbar in userform to go at the bottom of userform (and go to top too)

    Sorry for my english.

    Thank you.

  • #2
    Re: Scrollbar In Userforms

    When looking at your userform in design mode, press f4 and look for scroll bars for the various options.

    John

    Comment


    • #3
      Re: Scrollbar In Userforms

      Sorry. I'm not ask for the propieties. The scrollbar in my userform not work.

      I'm ajusted the propieties like scrollheight, scrollwidht, but I don't know how works.


      Thank you anyway.

      Comment


      • #4
        Re: Scrollbar In Userforms

        Create a userform with a label on it.
        Place this code in the userform.

        Private Sub UserForm_Initialize()

        With Me
        Label1.Move ((.InsideWidth - Label1.Width) / 2), ((.InsideHeight - Label1.Height) / 2)
        .ScrollBars = fmScrollBarsBoth
        .ScrollHeight = .InsideHeight * 2
        .ScrollWidth = .InsideWidth * 2
        End With

        End Sub


        When the userform is displayed the label will be in the center of the userform.
        The scrollbars will allow you to move the label up and left.

        Cheers
        Andy

        Comment


        • #5


          Re: Scrollbar In Userforms

          work fine. I have to use one big frame and put all my buttons, checkbox, textbox in the frame and .....

          thank you so much.


          gracias amigo.

          Comment

          Working...
          X