Tag Archives: Drawing

Drawing in Excel 8 – scaling and trimming

Posted on January 5, 2009 by

Previous Post – Drawing in Excel 7 Download PlotXY-xls.zip (XL 2003 and earlier) Download PlotXY-xlsb.zip (XL 2007) The previous post presented VBA routines to plot drawings in Excel from a series of coordinates, a list of connected points, and a … Continue reading →

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

Drawing in Excel 7 – Creating drawings from coordinates

Posted on November 11, 2008 by

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 , , , | 24 Comments

Drawing in Excel 6 – getting shape properties

Posted on September 17, 2008 by

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 July 26, 2008 by

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 July 15, 2008 by

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 July 4, 2008 by

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

Drawing in Excel – 2

Posted on June 22, 2008 by

Before getting down to basics, the attached file: Animation demo Illustrates how Excel shapes can be simply animated. Screen shot: The code for the animation (having previously drawn a circle and a rectangle with no fill, and noted their names): … Continue reading →

Posted in Drawing, Excel, Newton | Tagged , , , , | 19 Comments