Log in

View Full Version : ScrollBar Not Aligned In MultiPage Form VBA



Tony
10-28-2012, 09:50 PM
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.

Excel Fox
10-31-2012, 11:43 PM
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


Private Sub mpgMyMultiPage_Change()

mpgMyMultiPage.SelectedItem.ScrollLeft = 0
mpgMyMultiPage.SelectedItem.ScrollTop = 0

End Sub