Salut Ironfloflo,
Salut Archer,
Alimenter la ComboBox1 et éliminer la ligne-étude.
Private Sub UserForm_Initialize()
'
With Worksheets("PLANNING")
Me.ComboBox1.List = .Range("G3:G" & .Range("G" & Rows.Count).End(xlUp).Row).Value
End With
'
End Sub
Private Sub ComboBox1_Change()
'
Dim sItem$
'
sItem = Me.ComboBox1.Text
With Worksheets("PLANNING")
.Range("A" & .Range("G:G").Find(what:=sItem, lookat:=xlWhole, LookIn:=xlValues, searchdirection:=xlNext).Row).Resize(1, 100).Delete shift:=xlUp
End With
Unload Error
'
End Sub
... et la suite pour "Nouvelle étude"
Astuce : cherche à organiser le nom de tes contrôles pour faciliter le chargement ou la retranscription des valeurs dans une boucle.
Private Sub Maj_Click()
'
Dim iRow%
'
With Worksheets("PLANNING")
iRow = .Range("G" & Rows.Count).End(xlUp).Row + 1
For x = 1 To 11
.Cells(iRow, Choose(x, 7, 1, 2, 3, 4, 6, 8, 9, 10, 11, 12)) = Me.Controls("txt" & x).Text
Next
End With
'
End Sub
A+