Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I create a new pattern in Excel programmatically?
In Excel 2002 I can format a shape with a pattern. I can choose from 48
patterns in the list. If those patterns aren't suitable is there any way that I can specify an additional pattern? eg Can I add some patterns programmatically when Excel starts up? Here's what I do: 1) Add an AutoShape 2) Right click the AutoShape, choose Format Autoshape... 3) Choose Color dropdown 4) Select Fill Effects... 5) Choose Patterns tab 6) See 48 patterns, none of which are quite right At this point I'd like some more patterns to be available. I'm happy to write some VBA to get them in the list if possible. cheers, Jonathan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programmatically create html as input to Excel | Excel Programming | |||
Programmatically create button on Excel worksheet (vb.net) | Excel Programming | |||
Pattern search - Programmatically. | Excel Programming | |||
Create programmatically list of combinations for choices from data sets in excel vba | Excel Programming | |||
From Excel 97 Programmatically create access 97 or 2000 database and export data to. | Excel Programming |