ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to create Style.Interior.Gradient property (https://www.excelbanter.com/excel-programming/419182-how-create-style-interior-gradient-property.html)

Raja

How to create Style.Interior.Gradient property
 
In msdn library, i found that Interior object has two method :
1. OneColorGradient http://msdn.microsoft.com/en-us/library/bb256327.aspx
2. TwoColorGradient http://msdn.microsoft.com/en-us/library/bb256330.aspx

but i couldn't find them in Excel Inteop

Any ideas?

Regards,
Raja



Sheeloo[_3_]

How to create Style.Interior.Gradient property
 
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

_______________________________________________
"Raja" wrote:

In msdn library, i found that Interior object has two method :
1. OneColorGradient http://msdn.microsoft.com/en-us/library/bb256327.aspx
2. TwoColorGradient http://msdn.microsoft.com/en-us/library/bb256330.aspx

but i couldn't find them in Excel Inteop

Any ideas?

Regards,
Raja



JLGWhiz

How to create Style.Interior.Gradient property
 
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.

"Raja" wrote:

In msdn library, i found that Interior object has two method :
1. OneColorGradient http://msdn.microsoft.com/en-us/library/bb256327.aspx
2. TwoColorGradient http://msdn.microsoft.com/en-us/library/bb256330.aspx

but i couldn't find them in Excel Inteop

Any ideas?

Regards,
Raja




All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com