Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add new Patterns to AutoShapes in Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add new Patterns to AutoShapes in Excel
I can only find 48 patterns available in VBA for a Shape (xl2002).
-- Jim Cone Portland, Oregon USA "Jonathan McComb" wrote in message 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I put patterns in Excel charts | Charts and Charting in Excel | |||
Insert Autoshapes in excel | Excel Programming | |||
How to add patterns to excel tia sal2 | Excel Discussion (Misc queries) | |||
Numerical patterns in Excel | Excel Discussion (Misc queries) | |||
Excel cell patterns | Excel Discussion (Misc queries) |