Auto Scroll within a Userform Page

[r66eay]

I have a Userform that allows the user to click an item description which then automatically selects a different page - that bit was easy.

When the page is selected I want to effectively automatically scroll down to a specified point in the page. I am pretty sure it will have something to do with the value of ScrollTop but don't know how to code this.

So, following my code of 'MultiPage1.Value = 3' I then want the user to view the page such that ScrollTop Value = 1350

How do I do this?

 

[r66eay]

Have I asked a question with such an obvious answer that no-one has replied or is what I asked not possible?

When clicking a label in one page the user to redirected to another page but I want the user to view the page in such a way as the ScrollTop value is what I specify it to be, i.e. as if the user had scrolled down to that position.

Thanks

 

[Andrew Poulsom]

Try:

Private Sub MultiPage1_Change()
    If MultiPage1.Value = 3 Then
        Me.ScrollTop = 1350
    Else
        Me.ScrollTop = 0
    End If
End Sub