Excel userform scroll to top

Apple08

Active Member
Joined
Nov 1, 2014
Messages
450
Hi All

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!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Resolved: I have edit the height of the userform to make the length longer than the multipage length, and it works well now!
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top