As part of a major report, i need to change the color/s of a prenamed shape.
I need to color fill the shape as gradient in 2 colors.
I tried the following googled code, but i get an error with it.
Can anyone assist in the correct gradient fill syntax for the beloiw:
Please Login or Register to view this content.
This syntax works for me, you would need to determine the colors you wanted...
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the reply.
Is there a way to adapt that to RGB colors?
I have attached a dummy wkb.
No, but here's a handy pallete you can use to quickly spot the colorindex number for your desired color.
http://screencast.com/t/gyBGadXz
If you manually set your default shape to have a gradient fill then the following will work. It appears the object model is broken in as much as setting TwoColorGradient does not alter the Solid setting and makes calls to gradientstop properties fail.
you can set RGB directlyPlease Login or Register to view this content.
Please Login or Register to view this content.
Thanks for replying Andy.
I will give that code a go on Tues, and will post a reply.
I have had a slight issue with placing a xxx,xxx,xxx RGB set of numbers including comas in a cell, and instead of hard coding the RGB, referencing the cell with xxx,xxx,xxx value in it.
The result is not exactly to color expected for some reason.
Will have a play with it next week anyhow....
I'd split those RGB values out to separate cells if you're going to control it from the worksheet like that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks