Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007: create specifically named copies of an autoshape?
I have an autoshape, currently named "Oval 2"
I'm almost finished with the analytical part of my VBA, and now just need to render it to the UI. The user (an internal customer) will type in a list of numbers on Sheet1, and I need to create a copy of the autoshape for each number entered. That part is easy; Sheet2.Shapes("Oval 2").Copy Sheet2.Paste However, I immediately lose track of which new autoshape is which, since I haven't figured out how to assign specific names to the new autoshapes (e.g. "MyOval99"). I need to keep a master list of all the autoshapes on the page so I can delete them when the user puts in a new list of values, so I can create a new set of autoshapes to match the new values. The total number of values the user might enter is unknown. Question: is there a way to name the autoshape from VBA while creating it? I've played with the paste syntax, but haven't found anything that works yet. From there, I think it will be easy to delete all the shapes when they are no longer needed. Thanks! Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Back-up copies | Excel Discussion (Misc queries) | |||
autoshape on my chart got locked - Excel 2007 | Charts and Charting in Excel | |||
Trouble positioning an autoshape object using .Top in Excel 2007 | Excel Programming | |||
why does excel create multiple copies (as many as 18) of a file? | Excel Discussion (Misc queries) | |||
Why does Excel create multiple copies of the same file? | Excel Discussion (Misc queries) |