Sub mBoutons()
Dim Prenom As String, Prenoms, Couleurs, i&
Couleurs = Array(14166165, 13382400, 16721403, 13311, 10079232, 12752394, 644599, 5296274, 6299648)
Prenoms = Array("Sandy", "David", "Jessica", "Jean-François", "Daniel", "Jérémy", "Simon", "Jean-Pierre", "Francis")
Prenom = ActiveSheet.Shapes(Application.Caller).TextFrame.Characters.Text
i = Application.Match(Prenom, Prenoms, 0)
With Selection.Interior
.Pattern = xlPatternLinearGradient
.Gradient.Degree = 90: .Gradient.ColorStops.Clear
End With
With Selection.Interior.Gradient.ColorStops.Add(0)
.ThemeColor = xlThemeColorDark1: .TintAndShade = 0
End With
With Selection.Interior.Gradient.ColorStops.Add(1)
.Color = Couleurs(i - 1): .TintAndShade = 0
End With
End Sub