VB Code to Change the Color on boxes - gradient
 

I can not figure out how to select a box and change the background color
gradient to one of the standard selections? Any suggestions?

VB Code to Change the Color on boxes - gradient
 

What is a "box"?

Do you mean a "cell"?

HomeFormatFormat CellsFillFill Effects.

Pick a gradient.

If to be done automatically, when do you want this done and for which cell
or cells?


Gord Dibben MS Excel MVP

On Tue, 2 Feb 2010 12:33:01 -0800, Don
wrote:

I can not figure out how to select a box and change the background color
gradient to one of the standard selections? Any suggestions?

VB Code to Change the Color on boxes - gradient
 

sorry, not a cell, but a box that is linked to a macro or a button. I can
change the color of the box / button and change the effect but I do not know
how to change the color in VB - I have Excel 2007

"Gord Dibben" wrote:

What is a "box"?

Do you mean a "cell"?

HomeFormatFormat CellsFillFill Effects.

Pick a gradient.

If to be done automatically, when do you want this done and for which cell
or cells?


Gord Dibben MS Excel MVP

On Tue, 2 Feb 2010 12:33:01 -0800, Don
wrote:

I can not figure out how to select a box and change the background color
gradient to one of the standard selections? Any suggestions?

.

VB Code to Change the Color on boxes - gradient
 

I think I found the code, thanks

"Don" wrote:

I can not figure out how to select a box and change the background color
gradient to one of the standard selections? Any suggestions?