R
Ronbo
How do you find the name of an autoshape?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
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
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
R
Ronbo
Ronbo said:How do you find the name of an autoshape?
Never mind. I found a MsgBox routine on the discussion group from Dave
Peterson. Sorry.
R
Ronbo
Chip Pearson said: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
Thanks the Name Box is exactly what I looking for.