VB Code to Change the Color on boxes - gradient

D

Don

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

Gord Dibben

What is a "box"?

Do you mean a "cell"?

Home>Format>Format Cells>Fill>Fill 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
 
D

Don

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to gradient stops to background on master slide 0
Team Frame Fill and Arrows 0
Changing row background from external program 0
Need help modifying code 0
how to change color gradients in a bar chart 0
Removing Interpuncts or Mid-dots between syllables 0
Weekly Report 2
Student & Home? 1

Top