How do I Loop and Change Button Color???

Z

Zach

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

Don Guillett

This one liner should get you started.

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