Private Sub UserForm_Initialize()
Dim Nb, NbPages, X, Z As Byte
Nb = Sheets(1).Cells(1, 1).Value
NbPages = Me.MultiPage1.Pages.Count
For Z = 1 To NbPages
Me.MultiPage1.Pages("Page" & Z).Visible = False
Next Z
For X = 1 To Nb
Me.MultiPage1.Pages("Page" & X).Visible = True
Next X
End Sub