Private Sub Txt_AutPrestaServ_Change()
TXT_ValeurDuMouvement.Value = CDbl(Txt_VenMar.Value) + CDbl(Txt_ServComArt.Value) + CDbl(Txt_AutPrestaServ.Value) 'Met a jour TextBox Valeur du mouvement
End Sub
Private Sub Txt_ServComArt_Change()
TXT_ValeurDuMouvement.Value = CDbl(Txt_VenMar.Value) + CDbl(Txt_ServComArt.Value) + CDbl(Txt_AutPrestaServ.Value) 'Met a jour TextBox Valeur du mouvement
End Sub
Private Sub Txt_VenMar_Change()
TXT_ValeurDuMouvement.Value = CDbl(Txt_VenMar.Value) + CDbl(Txt_ServComArt.Value) + CDbl(Txt_AutPrestaServ.Value) 'Met a jour TextBox Valeur du mouvement
End Sub
Private Sub Txt_VenMar_KeyPress(ByVal keyascii As MSForms.ReturnInteger)
If InStr("0123456789,", Chr(keyascii)) = 0 And keyascii <> 32 Then
keyascii = 0 'on annule la pression sur la touche
' Else
' KeyAscii = Asc(UCase(Chr(KeyAscii)))
End If
End Sub
Private Sub Txt_ServComArt_KeyPress(ByVal keyascii As MSForms.ReturnInteger)
If InStr("0123456789,", Chr(keyascii)) = 0 And keyascii <> 32 Then
keyascii = 0 'on annule la pression sur la touche
' Else
' KeyAscii = Asc(UCase(Chr(KeyAscii)))
End If
End Sub
Private Sub Txt_AutPrestaServ_KeyPress(ByVal keyascii As MSForms.ReturnInteger)
If InStr("0123456789,", Chr(keyascii)) = 0 And keyascii <> 32 Then
keyascii = 0 'on annule la pression sur la touche
' Else
' KeyAscii = Asc(UCase(Chr(KeyAscii)))
End If
End Sub