Change User Form Page in VBA Form

Question

Good morning!

I have an User Form in VBA Excel with multiple Pages.

I want to create a command button ("Next" button) that allow the user to change the page. What code should I use?

Answer 1

This should do the trick :

If Me.MultiPage1.SelectedItem.Index<>Me.MultiPage1.Pages.Count Then
    Me.MultiPage1.Value = Me.MultiPage1.SelectedItem.Index + 1
Else
    Me.MultiPage1.Value = 0
End If