At the moment I am a little confused about the 'Name' property in the Shape class and the derived types. Excel lets you give a shape a custom name by using the 'Name Box' to the left of the function box. Those custom names are not reflected in the shape object's name for all types. I would need either those or the cell obtained via UpperLeftRow and UpperLeftColumn to identify the objects.
Here are my findings so far:
Shape type Default name Custom Name recognized Reference cell set
ComboBox \0sxxxx Yes Yes
Picture Picture x No Yes
TextBox TextBox x No Yes
Drawing shapes Unknown x No No (Always A1)
I havent tried for other objects so far but as you see, it is virtually impossible to identify the drawing objects for example. Can you shed some light on how those names are handled?
Thank you very much