Using VBA to create a 3-gradient fill in a newly created shape.
Posted on 2013-01-30
As we all know one of the more delightful improvements in Excel 2007 was removing the capability of recording shape formatting changes in VBA. I'm looking for the simplest way possible to create a 3-gradient fill in a newly created shape.
Something that in effect says this, only with the proper terms and syntax
shp.fill.gradientStop(1) = RGB(234,122,17)
shp.fill.gradientStop(1).stopPosition = 0%
shp.fill.gradientStop(2) = RGB(128,122,201)
shp.fill.gradientStop(2).stopPosition = 50%
shp.fill.gradientStop(3) = RGB(55,255,122)
shp.fill.gradientStop(3).stopPosition = 100%
shp.fill.gradientDirection = 90%
Given the fact that my terminology is probably all wrong, is it clear what I'm trying to accomplish? :- )