Bonjour,
J'aimerais savoir si j'ai la possibilité de réduire mon code ci-dessous car j'ai 17 images donc 17 click possibles :
'*******************************************************************
Sub Image0_Click()
'*******************************************************************
Sub Image1_Click()
'*******************************************************************
Sub Image2_Click()
'*******************************************************************
Sub Image4_Click()
'*******************************************************************
Ai-je la possibilité de faire une boucle sur les 17 images?
Merci d'avance pour vos retours car je ne vois pas trop comment l'automatiser
Eideal44
J'aimerais savoir si j'ai la possibilité de réduire mon code ci-dessous car j'ai 17 images donc 17 click possibles :
'*******************************************************************
Sub Image0_Click()
If Label78.Caption = "PRESENT AU CENTRE" Then
End SubLabel78.Caption = "PRESENT EN ENTREPRISE"
Label58.BackColor = &H80C0FF
Label78.BackColor = &H80C0FF
Label58.ForeColor = &H80000012
Label78.ForeColor = &H80000012
ElseIf Label78.Caption = "PRESENT EN ENTREPRISE" ThenLabel58.BackColor = &H80C0FF
Label78.BackColor = &H80C0FF
Label58.ForeColor = &H80000012
Label78.ForeColor = &H80000012
Label78.Caption = "PREVISIONNEL ENTREPRISE"
Label58.BackColor = &H80FFFF
Label78.BackColor = &H80FFFF
Label58.ForeColor = &H80000012
Label78.ForeColor = &H80000012
ElseIf Label78.Caption = "PREVISIONNEL ENTREPRISE" ThenLabel58.BackColor = &H80FFFF
Label78.BackColor = &H80FFFF
Label58.ForeColor = &H80000012
Label78.ForeColor = &H80000012
Label78.Caption = "PRESENT AU CENTRE"
Label58.BackColor = &HFFC0C0
Label78.BackColor = &HFFC0C0
Label58.ForeColor = &H80000012
Label78.ForeColor = &H80000012
End IfLabel58.BackColor = &HFFC0C0
Label78.BackColor = &HFFC0C0
Label58.ForeColor = &H80000012
Label78.ForeColor = &H80000012
'*******************************************************************
Sub Image1_Click()
If Label79.Caption = "PRESENT AU CENTRE" Then
Label79.Caption = "PRESENT EN ENTREPRISE"
Label59.BackColor = &H80C0FF
Label79.BackColor = &H80C0FF
Label59.ForeColor = &H80000012
Label79.ForeColor = &H80000012
Label59.BackColor = &H80C0FF
Label79.BackColor = &H80C0FF
Label59.ForeColor = &H80000012
Label79.ForeColor = &H80000012
ElseIf Label79.Caption = "PRESENT EN ENTREPRISE" Then
Label79.Caption = "PREVISIONNEL ENTREPRISE"
Label59.BackColor = &H80FFFF
Label79.BackColor = &H80FFFF
Label59.ForeColor = &H80000012
Label79.ForeColor = &H80000012
Label59.BackColor = &H80FFFF
Label79.BackColor = &H80FFFF
Label59.ForeColor = &H80000012
Label79.ForeColor = &H80000012
ElseIf Label79.Caption = "PREVISIONNEL ENTREPRISE" Then
Label79.Caption = "PRESENT AU CENTRE"
Label59.BackColor = &HFFC0C0
Label79.BackColor = &HFFC0C0
Label59.ForeColor = &H80000012
Label79.ForeColor = &H80000012
Label59.BackColor = &HFFC0C0
Label79.BackColor = &HFFC0C0
Label59.ForeColor = &H80000012
Label79.ForeColor = &H80000012
End If
End Sub
'*******************************************************************
Sub Image2_Click()
If Label80.Caption = "PRESENT AU CENTRE" Then
Label80.Caption = "PRESENT EN ENTREPRISE"
Label60.BackColor = &H80C0FF
Label80.BackColor = &H80C0FF
Label60.ForeColor = &H80000012
Label80.ForeColor = &H80000012
Label60.BackColor = &H80C0FF
Label80.BackColor = &H80C0FF
Label60.ForeColor = &H80000012
Label80.ForeColor = &H80000012
ElseIf Label80.Caption = "PRESENT EN ENTREPRISE" Then
Label80.Caption = "PREVISIONNEL ENTREPRISE"
Label60.BackColor = &H80FFFF
Label80.BackColor = &H80FFFF
Label60.ForeColor = &H80000012
Label80.ForeColor = &H80000012
Label60.BackColor = &H80FFFF
Label80.BackColor = &H80FFFF
Label60.ForeColor = &H80000012
Label80.ForeColor = &H80000012
ElseIf Label80.Caption = "PREVISIONNEL ENTREPRISE" Then
Label80.Caption = "PRESENT AU CENTRE"
Label60.BackColor = &HFFC0C0
Label80.BackColor = &HFFC0C0
Label60.ForeColor = &H80000012
Label80.ForeColor = &H80000012
Label60.BackColor = &HFFC0C0
Label80.BackColor = &HFFC0C0
Label60.ForeColor = &H80000012
Label80.ForeColor = &H80000012
End If
End Sub
'*******************************************************************
Sub Image4_Click()
If Label81.Caption = "PRESENT AU CENTRE" Then
Label81.Caption = "PRESENT EN ENTREPRISE"
Label61.BackColor = &H80C0FF
Label81.BackColor = &H80C0FF
Label61.ForeColor = &H80000012
Label81.ForeColor = &H80000012
Label61.BackColor = &H80C0FF
Label81.BackColor = &H80C0FF
Label61.ForeColor = &H80000012
Label81.ForeColor = &H80000012
ElseIf Label81.Caption = "PRESENT EN ENTREPRISE" Then
Label81.Caption = "PREVISIONNEL ENTREPRISE"
Label61.BackColor = &H80FFFF
Label81.BackColor = &H80FFFF
Label61.ForeColor = &H80000012
Label81.ForeColor = &H80000012
Label61.BackColor = &H80FFFF
Label81.BackColor = &H80FFFF
Label61.ForeColor = &H80000012
Label81.ForeColor = &H80000012
ElseIf Label81.Caption = "PREVISIONNEL ENTREPRISE" Then
Label81.Caption = "PRESENT AU CENTRE"
Label61.BackColor = &HFFC0C0
Label81.BackColor = &HFFC0C0
Label61.ForeColor = &H80000012
Label81.ForeColor = &H80000012
Label61.BackColor = &HFFC0C0
Label81.BackColor = &HFFC0C0
Label61.ForeColor = &H80000012
Label81.ForeColor = &H80000012
End If
End Sub
'*******************************************************************
Ai-je la possibilité de faire une boucle sur les 17 images?
Merci d'avance pour vos retours car je ne vois pas trop comment l'automatiser
Eideal44
Dernière édition: