| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change gradient color in chart for Excel 2007 | Charts and Charting in Excel | |||
| Check boxes and text strikethrough / color change | Excel Worksheet Functions | |||
| VBA Code; need linked cells to change color if condition met | Excel Worksheet Functions | |||
| Fixed color gradient | Charts and Charting in Excel | |||
| color gradient in a worksheet (not a chart), Is it Possible? | Excel Worksheet Functions | |||
Hybrid Mode
