Hi All
I have an annoying problem to keep the userform scroll to the top (0), although I have used the code:
and
When the userform is loaded, it default the Page 1 when load but the userform scroll top keep staying as 28 instead of 0. I have to move the userform scroll bar back to the top to see the multipage tabs. After I select a tab in the multipages, it doesn't move to the right tab but still show me the default tab (scroll back to 28 again!). It only let me to view all tabs and changed after repeating the scroll top process. Also, I have a 'calculate' command button, once I click the button then the scroll bar will go back to 28 instead of 0. I have tried to Call 'MultiplePage_Change' after the 'Calculate' code, however it doesn't work.
Any help is appreciated! Many thanks!
I have an annoying problem to keep the userform scroll to the top (0), although I have used the code:
Code:
Private Sub MultiPage1_Change()
Me.ScrollTop = 0
End Sub
and
Code:
Private Sub UserForm_Initialize()
UserForm1.MultiPage1.Value = 0
End Sub
When the userform is loaded, it default the Page 1 when load but the userform scroll top keep staying as 28 instead of 0. I have to move the userform scroll bar back to the top to see the multipage tabs. After I select a tab in the multipages, it doesn't move to the right tab but still show me the default tab (scroll back to 28 again!). It only let me to view all tabs and changed after repeating the scroll top process. Also, I have a 'calculate' command button, once I click the button then the scroll bar will go back to 28 instead of 0. I have tried to Call 'MultiplePage_Change' after the 'Calculate' code, however it doesn't work.
Any help is appreciated! Many thanks!