Bonjour tt le monde,
Je voudrais raccourcir un bout de programme mais je ne suis pas assez calé...
Voici donc,
Private Sub UserForm_Initialize()
With SB_P_01
.Min = 0
.Max = 5
.SmallChange = 1
End With
With SB_P_02
.Min = 0
.Max = 5
.SmallChange = 1
End With
With SB_P_03
.Min = 0
.Max = 5
.SmallChange = 1
End With
With SB_P_04
.Min = 0
.Max = 5
.SmallChange = 1
End With
With SB_P_05
.Min = 0
.Max = 5
.SmallChange = 1
End With
With SB_P_06
.Min = 0
.Max = 5
.SmallChange = 1
End With
End Sub
Qq'un pourrait me dire si il y a qq chose à faire ?
Merci d'avance, bonne journée !!!
@lex
Je voudrais raccourcir un bout de programme mais je ne suis pas assez calé...
Voici donc,
Private Sub UserForm_Initialize()
With SB_P_01
.Min = 0
.Max = 5
.SmallChange = 1
End With
With SB_P_02
.Min = 0
.Max = 5
.SmallChange = 1
End With
With SB_P_03
.Min = 0
.Max = 5
.SmallChange = 1
End With
With SB_P_04
.Min = 0
.Max = 5
.SmallChange = 1
End With
With SB_P_05
.Min = 0
.Max = 5
.SmallChange = 1
End With
With SB_P_06
.Min = 0
.Max = 5
.SmallChange = 1
End With
End Sub
Qq'un pourrait me dire si il y a qq chose à faire ?
Merci d'avance, bonne journée !!!
@lex