Danny's VBA Scripts

Name

Returns

Description

Read-only. Parameters: Index. Returns a ShapeRange object containing only some of the shapes in the Shapes collection

AddCallout

Shape

Method. Parameters: Type As MsoCalloutType, Left As Single,Top As Single, Width As Single, Height As Single. Adds a callout line shape to the collection

AddChart

Shape

Method. Parameters: Type As xlChartType, Left, Top, Width, Height. Adds a chart at a specified location

AddConnector

Shape

Method. Parameters: Type As MsoConnectorType, BeginX As Single, BeginY As Single, EndX As Single, EndY As Single. Adds a connector shape to the collection

AddCurve

Shape

Method. Parameters: SafeArrayOfPoints. Adds a Bezier curve to the collection

AddFormControl

Shape

Method. Parameters: Type As XlFormControl, Left As Long, Top As Long, Width As Long, Height As Long. Adds an Excel control to the collection

AddLabel

Shape

Method. Parameters: Orientation As MsoText-Orientation, Left As Single, Top As Single, Width As Single, Height As Single. Adds a label to the collection

AddLine

Shape

Method. Parameters: BeginX As Single, BeginY As Single, EndX As Single, EndY As Single. Adds a line shape to the collection

AddOLEObject

Shape

Method. Parameters: [ClassType], [Filename], [Link], [DisplayAslcon],[IconFileName], [Iconlndex], [IconLabel], [Left], [Top], [Width], [Height]. Adds an OLE control to the collection

AddPicture

Shape

Method. Parameters: Filename As String, LinkToFile As MsoTriState, SaveWithDocument As MsoTriState,Left As Single, Top As Single, Width As Single, Height As Single. Adds a picture object to the collection

Name

Returns

Description

AddPolyline

Shape

Method. Parameters: SafeArrayOfPoints. Adds an open polyline or a closed polygon to the collection

AddShape

Shape

Method. Parameters: Type As MsoAutoShapeType, Left As Single,Top As Single, Width As Single, Height As Single. Adds a shape using the Type parameter to the collection

AddTextbox

Shape

Method. Parameters: Orientation As MsoTextOrien-tation, Left As Single, Top As Single, Width As Single, Height As Single. Adds a textbox to the collection

AddText Effect

Shape

Method. Parameters: PresetTextEffect As MsoPresetTextEffect,Text As String, FontName As String, FontSize As Single, FontBold As MsoTriState, FontItalic As MsoTriState,Left As Single, Top As Single. Adds a WordArt object to the collection

Build Freeform

Freeform Builder

Method. Parameters: EditingType As MsoEditingType, X1 As Single, Y1 As Single. Accesses an object that allows creation of a new shape based on ShapeNode objects