How do I Loop and Change Button Color???

's Computer Specifications

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

's Computer Specifications

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
(E-Mail Removed)
"Zach" <(E-Mail Removed)> wrote in message
news:be9689b0-b27e-41ac-bc63-(E-Mail Removed)...
> How do I loop through a column and change different button's colors
> based on corresponding cells values??

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: Loop range change a cell color	B Lynn B	Microsoft Excel Programming	1	11th Nov 2009 07:44 PM
Re: Command Button Color For Next Loop	John Wilson	Microsoft Excel Programming	0	15th Sep 2005 05:57 PM
Re: Command Button Color For Next Loop	John Wilson	Microsoft Excel Programming	0	15th Sep 2005 05:56 PM
Need to loop thru cells and change background color	Ian Wolstenholme	Microsoft Excel Discussion	6	8th Feb 2005 11:07 PM
If loop to change background color	BravoGolf - ExcelForums.com	Microsoft Excel Misc	2	27th Sep 2004 11:12 AM