Drawing in Excel 6 – getting shape properties

Previous post

One of the less than useful new “features” of Excel 2007 is that its macro recorder no longer records operations on shapes, which removes the easiest way to discover the exact names of shape properties, and how to manipulate them.  The file ShapeProps.zip contains a spreadheet with a User Defined Function (UDF) that will return a list of property names, and the values for each property, for any named shape.  In addition it will generate VBA code to read aditional properties if the correct property names are inserted in a list on the spreadsheet.


The UDF currently reads 94 different properties, which can either be returned as a column array of all 94 values, or if a list of property numbers is entered only the listed property values will be returned.  See the screen shot below for examples.

ShapeProp() Output

ShapeProp() Output

ShapeProp() code generation sheet

ShapeProp() code generation sheet

This entry was posted in Drawing, Excel, UDFs, VBA and tagged , , , , . Bookmark the permalink.

5 Responses to Drawing in Excel 6 – getting shape properties

  1. Pingback: Weekly Excel Links - Moved to Seattle Edition | Pointy Haired Dilbert - Chandoo.org

  2. Pingback: Drawing in Excel 7 - Creating drawings from coordinates « Newton Excel Bach, not (just) an Excel Blog

  3. vittorio says:


    I’m looking for help to solve a problem with an excel sheet.
    I need a visual basic routine that make this thing:
    i’ve created a sheet where i draw simple form (lines, square) and the using a form i’ll insert the name for that form. I ‘d like to automaitcally add the name that i’ve inserted close to the form.
    Do you have any idea on how to do that?
    thanks in advance



  4. dougaj4 says:

    Hi Vittorio

    Could you e-mail a sample and I’ll have a look at it.

    dougaj4 at gmail


  5. Pingback: Daily Download 8: Drawing in Excel | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s