Correct syntax for Gradient fill of shape

[coreytroy]

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.

[JBeaucaire]

This syntax works for me, you would need to determine the colors you wanted...

Please Login or Register  to view this content.

[coreytroy]

Thanks for the reply.
Is there a way to adapt that to RGB colors?

I have attached a dummy wkb.

[JBeaucaire]

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

[Andy Pope]

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.

Please Login or Register  to view this content.

you can set RGB directly

Please Login or Register  to view this content.

[coreytroy]

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....

[JBeaucaire]

I'd split those RGB values out to separate cells if you're going to control it from the worksheet like that.