Results 1 to 2 of 2

Thread: ScrollBar Not Aligned In MultiPage Form VBA

  1. #1
    Junior Member
    Join Date
    Oct 2012
    Posts
    26
    Rep Power
    0

    ScrollBar Not Aligned In MultiPage Form VBA

    Hello,

    I have a problem regarding the scrollbar alignment properties of the multitab.

    I have 3 pages in a multitab. Each tab has different scroll sizes.

    The thing is when i run the userform and click on the first tab the scrollleft and scrolltop are 0 as it should be. But when i click on the next two tabs the scrollleft and top will be set to an automatic size so the content in the multipage will not be aligned to the top left.

    How can i solve this that every page in the multipage will be aligned every time top left.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Tony, I tried to replicate your problem, but couldn't. So I am going ahead with what I think may suffice as a solution. Try forcing the ScrollLeft and ScrollTop to zero during each switch

    Code:
    Private Sub mpgMyMultiPage_Change()
    
        mpgMyMultiPage.SelectedItem.ScrollLeft = 0
        mpgMyMultiPage.SelectedItem.ScrollTop = 0
    
    End Sub
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Populate data in form
    By Ryan_Bernal in forum Excel Help
    Replies: 4
    Last Post: 02-01-2013, 10:18 AM
  2. Search form on work sheet
    By Ryan_Bernal in forum Excel Help
    Replies: 5
    Last Post: 01-15-2013, 11:46 AM
  3. Form suddenly disappears
    By tfurnivall in forum Access Help
    Replies: 3
    Last Post: 12-20-2012, 06:47 PM
  4. Replies: 8
    Last Post: 10-06-2011, 01:29 PM
  5. Animation on Form Control
    By Mechanic in forum Excel Help
    Replies: 4
    Last Post: 03-22-2011, 08:56 AM

Posting Permissions

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