Mike,
Search up (VBA-View-)ObjectBrowser for msoShapeType.
--
Petr Bezucha


"Mike Faulkner" wrote:

App: Excel 2002
OS: WinXP

Looping through the Shapes collection in a Worksheet I get three different
Types returned (i.e. 13, 17 & 1) . How can I then identify what Type of Shape
these are (i.e, Texbox, Picture, Comment etc.)

Many thanks in advance

Regards
Mike