Option Explicit
Private Sub UserForm_Initialize()
With SpinButton1
.Min = 25
.Max = 45
.Value = mavaleur
TextBox1 = mavaleur
End With
End Sub
Private Sub SpinButton1_SpinDown()
TextBox1 = SpinButton1
mavaleur = mavaleur - 1
End Sub
Private Sub SpinButton1_SpinUp()
TextBox1 = SpinButton1
mavaleur = mavaleur + 1
End Sub