Private Sub CommandButton5_Click() 'Private Sub Valider_Click()
With ActiveSheet
ligne = .Range("A65635").End(xlUp).Row + 1
if me.combobx1.value<>"" then
.Cells(ligne, 1).Value = Me.ComboBox1.value
else
.Cells(ligne, 1).Value = Me.ComboBox2.value
endif
lblmessage2 = "Transfert effectué"
End With
EffaceTout
ComboBox1.SetFocus
[A65789].End(xlUp).Offset(1, 0).Select
End Sub