NAME OF AUTOSHAPE
 

How do you find the name of an autoshape?

If you select the shape, its name will appear in the Name Box to
the left of the Formula Bar. In VBA, you can use Selection.Name


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ronbo" wrote in message
...
How do you find the name of an autoshape?

"Ronbo" wrote:

How do you find the name of an autoshape?

Never mind. I found a MsgBox routine on the discussion group from Dave
Peterson. Sorry.

"Chip Pearson" wrote:

If you select the shape, its name will appear in the Name Box to
the left of the Formula Bar. In VBA, you can use Selection.Name


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Ronbo" wrote in message
...
How do you find the name of an autoshape?


Thanks the Name Box is exactly what I looking for.