Dim PageSelect As Byte Private Sub CommandButton1_Click() PageSelect = IIf(PageSelect = 0, MultiPage1.Pages.Count - 1, PageSelect - 1) EnabledMulti End Sub Private Sub CommandButton2_Click() PageSelect = IIf(PageSelect = MultiPage1.Pages.Count - 1, 0, PageSelect + 1) EnabledMulti End Sub Private Sub UserForm_Initialize() PageSelect = 0 EnabledMulti End Sub Sub EnabledMulti() Dim bCpt As Byte With MultiPage1 For bCpt = 0 To MultiPage1.Pages.Count - 1 .Pages(bCpt).Enabled = False Next bCpt .Pages(PageSelect).Enabled = True .Value = PageSelect End With End Sub
Me.MPage.Value = 0
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub UserForm_Initialize() MultiPage1.Style = 1 End Sub
Private Sub UserForm_Initialize() MultiPage1.Style = 1 MultiPage1.ForeColor = &H8080FF End Sub
La couleur ne s'applique pas à l'onglet mais au fond page
18 mars 2015 à 15:36