How to create Style.Interior.Gradient property

  • Thread starter Thread starter Raja
  • Start date Start date
I think One of them is available only in Excel 2007...

Found the following in Excel 2003 Help
_______________________________________________
With Charts(1).ChartArea.Fill
.Visible = True
.ForeColor.SchemeColor = 15
.BackColor.SchemeColor = 17
.TwoColorGradient msoGradientHorizontal, 1
End With

_______________________________________________
 
In the VB editor for Excel help files, look for Gradient. That will bring up
any propeties that apply to color gradients. I believe they all apply to
either charts or shape objects.
 
Back
Top