Changing object fill pattern in Excel

T

theBruceGuy

I am trying to change the Legendkey object in excel from an Access database.

Everything works correctly except the line:

xlApp.ActiveChart.Legend.LegendEntries(5).LegendKey.Fill.Patterned
Pattern:=msoPatternDarkHorizontal

It appears that it doesn't like any of the mso pattern types. How can I
accomplsih the change?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access VBA - Excel MSO Fill Pattern not Recognised? 0
Team Frame Fill and Arrows 0
VSTO C# add in Outlook.Appointment error 0
Visio 2010 Programmatically change Shape fill color using C# 0
Patterns for Object Fill Effects Do Not Remain in Place 2
Chart pattern fills in Publisher 2007 1
Object Browser in VBA 0
Error loadingtype library/DLL. 0

Top