How do I Loop and Change Button Color???

  • Thread starter Thread starter Zach
  • Start date Start date
Z

Zach

How do I loop through a column and change different button's colors
based on corresponding cells values??
 
This one liner should get you started.

Sub changeShapecolor()
ActiveSheet.Shapes("Rectangle 9") _
.Fill.ForeColor.SchemeColor = 12
End Sub
 
Back
Top