Wednesday, January 30, 2008

How To Name a Shape in VBA for Excel

A post I made earlier required the coder to refer to a shape.  Here is an easy way to determine the name of the shape or to set the name of the shape. 

Naming a shape is just like naming a cell.  If you click the shape, a box in the top left corner of your excel workbook should give the name of the shape.  By the same token, you can name the shape by overwriting the current, generic, name in the same box.  It is exactly like naming a cell.

No comments: