Description
Represents a graphic object created by the Freehand, Freeform, or Filled Freeform buttons.
Accessors
The Drawing object is a member of the Drawings collection. The Drawings collection contains all the Drawing objects on a single sheet. Do not confuse the Drawings collection with the DrawingObjects collection, which contains all the graphic objects and controls on a single sheet. Use the Add method to create a new drawing and add it to the collection.
To access a single member of the collection, use the Drawings method with the index number or name of the drawing as an argument.
The following example sets the interior color for drawing one on the worksheet named "Sheet1."
Worksheets("sheet1").Drawings(1).Interior.Color = RGB(0, 0, 255)
The drawing name is shown in the Name Box when the drawing is selected. Use the Name property to return or set the name of the drawing. The following example aligns the left edge of the drawing named "Drawing 1" with the left edge of cell C5.
Worksheets("sheet1").Drawings("drawing 1").Left = _
Worksheets("sheet1").Range("c5").Left
Properties
Application Property, Border Property, BottomRightCell Property, Creator Property, Enabled Property, Height Property, Index Property, Interior Property, Left Property, Locked Property, Name Property, OnAction Property, Parent Property, Placement Property, PrintObject Property, Shadow Property, Top Property, TopLeftCell Property, Vertices Property, Visible Property, Width Property, ZOrder Property.
Methods
AddVertex Method, BringToFront Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Reshape Method, Select Method, SendToBack Method.