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
| Sub couleur()
'
' couleur Macro
' déclaration des variables pour les trois départements
Dim coul_Var As String
Dim coul_AM As String
Dim coul_Vaucluse As String
'on stocke la couleur de la feuille dans la variable
coul_Var = LCase(Range("q35").Value)
coul_AM = LCase(Range("r35").Value)
coul_Vaucluse = LCase(Range("s35").Value)
'changement de la couleur pour les alpes maritime
ActiveSheet.Shapes.Range(Array("Freeform 2395")).Select 'AM
Select Case coul_Var
Case Is = "orange"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 192, 0) 'orange
Case Is = "rouge"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 0, 0) 'rouge
Case Is = "vert"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(0, 176, 80) 'vert
Case Is = "jaune"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 255, 0) 'jaune
Case Is = "violet"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(112, 48, 160) 'violet
End Select
'changement de la couleur pour le Var
ActiveSheet.Shapes.Range(Array("Freeform 2399")).Select 'var
Select Case coul_AM
Case Is = "orange"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 192, 0) 'orange
Case Is = "rouge"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 0, 0) 'rouge
Case Is = "vert"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(0, 176, 80) 'vert
Case Is = "jaune"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 255, 0) 'jaune
Case Is = "violet"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(112, 48, 160) 'violet
End Select
'changement de la couleur pour le vaucluse
ActiveSheet.Shapes.Range(Array("Freeform 2404")).Select 'vaucluse
Select Case coul_Vaucluse
Case Is = "orange"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 192, 0) 'orange
Case Is = "rouge"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 0, 0) 'rouge
Case Is = "vert"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(0, 176, 80) 'vert
Case Is = "jaune"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 255, 0) 'jaune
Case Is = "violet"
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(112, 48, 160) 'violet
End Select
' a la fin retour dans la feuille
Range("R12").Select
End Sub |
Partager