Tag Archives: shapes

Drawing in Excel 7 – Creating drawings from coordinates

Posted on 11/11/2008 by dougaj4

Previous Post, Drawing in Excel 6 The file PlotXYcontains routines to plot scale drawings in Excel from a list of XY coordinates of node points, node points for each shape, and formatting details for each shape type.  The plot is scaled … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , | 25 Comments

Drawing in Excel 6 – getting shape properties

Posted on 17/09/2008 by dougaj4

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 … Continue reading →

Posted in Drawing, Excel, UDFs, VBA | Tagged , , , , | 5 Comments

Drawing in Excel 5 – Shape List

Posted on 26/07/2008 by dougaj4

Previous Post For some reason best known to Microsoft, the Excel documentation does not include a graphic list of shapes with an example of each shape, and the text list they do provide is incomplete.  The file shapelist.zip rectifies that … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , | 4 Comments

Drawing in Excel-4

Posted on 15/07/2008 by dougaj4

This post will look in a bit more detail at the methods presented in the previous post.  It would be a good idea to open the previous post on another tab, or download the example file and open the code … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , | 3 Comments

Drawing in Excel-3

Posted on 04/07/2008 by dougaj4

Previous post OK, here are some of the promised basics of using VBA to create drawings in Excel. This and following posts will cover: The shape objects and how to create them How to select, group, and delete shapes How … Continue reading →

Posted in Drawing, Excel | Tagged , , , | 6 Comments