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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
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,216,008
Messages
6,128,256
Members
449,435
Latest member
Jahmia0616

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