1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
|
' **************************************
' Traitement des codes compétences bénévoles*******************************
'***************************************
Private Sub ComboBox4_Change()
Dim ligne As Long
Dim i As Integer
Dim chemin As String
Dim ws4 As Variant
Set ws4 = Sheets("liste competences par personnes")
'Dim j As Integer
If Me.ComboBox4.ListIndex = -1 Then Exit Sub
ligne = Me.ComboBox4.ListIndex + 2
' **************************************
' Traitement des compétences - bénévoles
' nomprenom du bénévole code et partage
'***************************************
Dim h As Integer
With ComboBox4
Rem données code - bénévole
Me.ComboBox4 = ws4.Cells(ligne, "A") ' codenomprénom
Me.TextBox4 = ws4.Cells(ligne, "B") ' code
Me.TextBox5 = ws4.Cells(ligne, "C") ' Nom
Me.TextBox6 = ws4.Cells(ligne, "D") ' PréNom
Me.TextBox2 = ws4.Cells(ligne, "E") 'partage
End With
' **************************************
' tri ********************************
'***************************************
Call TRIBENCOMP
End Sub |
Partager