| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop range change a cell color | Excel Programming | |||
| Trying to loop through all shapes on multiple worksheets and change color | Excel Programming | |||
| how to get my button on a for mto change color | Excel Programming | |||
| Command Button Color For Next Loop | Excel Programming | |||
| Loop to change cell color based on found value? | Excel Programming | |||
Linear Mode
