Bonjour
J'ai 19 Usf qui peuvent alimenter chaque fois la feuille active.
Comme suit:
Private Sub Quitter1_Click()
Unload UsfLA1
End Sub
Private Sub TextBox3_Change()
Sheets(ActiveSheet.Name).Cells(19, 7) = TextBox3
End Sub
Private Sub TextBox4_Change()
Sheets(ActiveSheet.Name).Cells(19, 9) = TextBox4
End Sub
Private Sub TextBox5_Change()
Sheets(ActiveSheet.Name).Cells(19, 11) = TextBox5
End Sub
Private Sub TextBox6_Change()
Sheets(ActiveSheet.Name).Cells(19, 13) = TextBox6
End Sub
Private Sub TextBox7_Change()
Sheets(ActiveSheet.Name).Cells(19, 15) = TextBox7
End Sub
Private Sub TextBox8_Change()
Sheets(ActiveSheet.Name).Cells(19, 17) = TextBox8
End Sub
Private Sub UserForm_Initialize()
TextBox3 = Sheets(ActiveSheet.Name).Cells(19, 7)
TextBox4 = Sheets(ActiveSheet.Name).Cells(19, 9)
TextBox5 = Sheets(ActiveSheet.Name).Cells(19, 11)
TextBox6 = Sheets(ActiveSheet.Name).Cells(19, 13)
TextBox7 = Sheets(ActiveSheet.Name).Cells(19, 15)
TextBox8 = Sheets(ActiveSheet.Name).Cells(19, 17)
End Sub
Je ne comprend pas pourquoi il garde les données?