How do I Loop and Change Button Color???
 

How do I loop through a column and change different button's colors
based on corresponding cells values??

How do I Loop and Change Button Color???
 

This one liner should get you started.

Sub changeShapecolor()
ActiveSheet.Shapes("Rectangle 9") _
.Fill.ForeColor.SchemeColor = 12
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Zach" wrote in message
...
How do I loop through a column and change different button's colors
based on corresponding cells values??