Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / 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,314

    Re: Scrollbar In Userforms

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

    VB:
    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


  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, 22:08
  2. Print UserForm With Scrollbars
    By NUBoomer in forum EXCEL HELP
    Replies: 4
    Last Post: December 28th, 2006, 20:04
  3. Reset Userform Scrollbars
    By abbeville in forum EXCEL HELP
    Replies: 6
    Last Post: September 17th, 2006, 20:32
  4. scrollbars
    By gillrajb in forum EXCEL HELP
    Replies: 1
    Last Post: May 27th, 2006, 04:07
  5. scrollbars
    By cccquilter in forum EXCEL HELP
    Replies: 1
    Last Post: October 1st, 2004, 04: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