Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Scrollbars On Userform

  1. #1
    Join Date
    28th October 2006
    Posts
    4

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    23rd September 2003
    Location
    York
    Posts
    880

    Re: Scrollbar In Userforms

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

    John

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    28th October 2006
    Posts
    4

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Scrollbar In Userforms

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

    [vba]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[/vba]

    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


  5. #5
    Join Date
    28th October 2006
    Posts
    4

    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.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Scrollbars With Image
    By cs2007 in forum Excel and/or Access Help
    Replies: 4
    Last Post: May 21st, 2007, 23:08
  2. Print UserForm With Scrollbars
    By NUBoomer in forum EXCEL HELP
    Replies: 4
    Last Post: December 28th, 2006, 21:04
  3. Reset Userform Scrollbars
    By abbeville in forum EXCEL HELP
    Replies: 6
    Last Post: September 17th, 2006, 21:32
  4. scrollbars
    By gillrajb in forum EXCEL HELP
    Replies: 1
    Last Post: May 27th, 2006, 05:07
  5. scrollbars
    By cccquilter in forum EXCEL HELP
    Replies: 1
    Last Post: October 1st, 2004, 05:53

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno