首页 > 代码库 > VBA学习笔记(4)-Section, Row, and Cell Indices for Shapes

VBA学习笔记(4)-Section, Row, and Cell Indices for Shapes

Section or row

Cell

Section index

Row index

Cell index

<no name>1

HelpTopic
Copyright2

visSectionObject

visRowHelpCopyright

visObjHelp
visCopyright

1-D Endpoints
section3

BeginX
BeginY
EndX
EndY

visSectionObject

visRowXForm1D

vis1DBeginX
vis1DBeginY
vis1DEndX
vis1DEndY

Actions
section

Actions.Action[i]
Actions.Menu[i]
Actions.Ci
Actions.Di

visSectionAction

visRowAction + i

visActionAction
visActionMenuvisActionChecked
visActionDisabled

Alignment
section4

AlignLeft
AlignCenter
AlignRight
AlignTop
AlignMiddle
AlignBottom

visSectionObject

visRowAlign

visAlignLeft
visAlignCenter
visAlignRight
visAlignTop
visAlignMiddle
visAlignBottom

Character
section

Char.Font[i]
Char.Size[i]
Char.FontScale[i]
Char.Letterspace[i]
Char.Color[i]
Char.Style[i]
Char.Case[i]
Char.Pos[i]
Char.Strikethru[i]
Char.DblUnderline[i]
Char.Overline[i]
Char.Perpendicular[i]
Char.Locale[i]5
Char.ColorTrans[i]

visSectionCharacter

visRowCharacter + i

visCharacterFont
visCharacterSize
visCharacterFontScale
visCharacterLetterspace
visCharacterColor
visCharacterStyle
visCharacterCase
visCharacterPos
visCharacterStrikethru
visCharacterDblUnderline
visCharacterOverline
visCharacterPerpendicular
visCharacterLocale
visCharacterColorTrans

Connection
Points
section
(non-extended row6)

Connections.Xi
Connections.Yi
Connections.DirX[i]
Connections.DirY[i]
Connections.Type[i]
Connections.AutoGen[i]

visSectionConnectionPts

visRowConnectionPts + i

visCnnctX
visCnnctY
visCnnctDirX
visCnnctDirY
visCnnctType
visCnnctAutoGen

Connection
Points
section
(extended row7)

Connections.Xi
Connections.Yi
Connections.Ai
Connections.Bi
Connections.Ci
Connections.Di

visSectionConnectionPts

visRowConnectionPts + i

visCnnctX
visCnnctY
visCnnctA
visCnnctB
visCnnctC
visCnnctD

Controls
section

Controls.Xi
Controls.Yi
Controls.XDyn[i]
Controls.YDyn[i]
Controls.XCon[i]
Controls.YCon[i]
Controls.CanGlue[i]
Controls.Prompt[i]8

visSectionControls

visRowControl + i

visCtlX
visCtlY
visCtlXDyn
visCtlYDyn
visCtlXCon
visCtlYCon
visCtlGlue
visCtlTip

Custom
Properties
section

Prop.Name.Label
Prop.Name.Prompt
Prop.Name.SortKey
Prop.Name.Type
Prop.Name.Format
Prop.Name.Value9
Prop.Name.Invisible
Prop.Name.Verify

visSectionProp

visRowProp + i

visCustPropsLabel
visCustPropsPrompt
visCustPropsSortKey
visCustPropsType
visCustPropsFormat
visCustPropsValue
visCustPropsInvis
visCustPropsAsk

Events section

TheData10
TheText
EventDblClick
EventXFMod
EventDrop

visSectionObject

visRowEvent

visEvtCellTheData
visEvtCellTheText
visEvtCellDblClick
visEvtCellXFMod
visEvtCellDrop

Fill Format section

FillBkgnd
FillPattern
FillForegnd
ShdwBkgnd
ShdwPattern
ShdwForegnd
FillForegndTrans
FillBkgndTrans
ShdwForegndTrans
ShdwBkgndTrans

visSectionObject

visRowFill

visFillBkgnd
visFillPattern
visFillForegnd
visFillShdwBkgnd
visFillShdwPattern
visFillShdwForegnd
visFillForegndTrans
visFillBkgndTrans
visFillShdwForegndTrans
visFillShdwBkgndTrans

Foreign Image Info section11

ImgWidth
ImgHeight
ImgOffsetY
ImgOffsetX

visSectionObject

visRowForeign

visFrgnImgWidth
visFrgnImgHeight
visFrgnImgOffsetY
visFrgnImgOffsetX

Geometryisection

Geometryi.NoFill
Geometryi.NoLine
Geometryi.NoShow
Geometryi.NoSnap

VisSectionFirstComponent + i

visRowComponent

visCompNoFill
visCompNoLine
visCompNoShow
visCompNoSnap

MoveTo row
(in Geometryisection)

Geometryi.Xj
Geometryi.Yj

 

visRowVertex + j

visX
visY

LineTo row
(in Geometryisection)

Geometryi.Xj
Geometryi.Yj

 

visRowVertex + j

visX
visY

ArcTo row
(in Geometryisection)

Geometryi.Xj
Geometryi.Yj
Geometryi.Aj

 

visRowVertex + j

visX
visY
visBow

EllipticalArcTo row
(in Geometryisection)

Geometryi.Xj
Geometryi.Yj
Geometryi.Aj
Geometryi.Bj
Geometryi.Cj
Geometryi.Dj

 

visRowVertex + j

visX
visY
visControlX
visControlY
visEccentricityAngle
visAspectRatio

PolylineTo row
(in Geometryisection)

Geometryi.Xj
Geometryi.Yj
Geometryi.Aj

 

visRowVertex + j

visX
visY
visPolylineData

NURBSTo row
(in Geometryisection)

Geometryi.Xj
Geometryi.Yj
Geometryi.Aj
Geometryi.Bj
Geometryi.Cj
Geometryi.Dj
Geometryi.Ej

 

visRowVertex + j

visX
visY
visNURBSKnot
visNURBSWeight
visNURBSKnotPrev
visNURBSWeightPrev
visNURBSData

SplineStart row (in Geometryisection)

Geometryi.Xj
Geometryi.Yj
Geometryi.Aj
Geometryi.Bj
Geometryi.Cj
Geometryi.Dj

 

visRowVertex + j

visX
visY
visSplineKnot
visSplineKnot2
visSplineKnot3
visSplineDegree

SplineKnot row
(in Geometryisection)

Geometryi.Xj
Geometryi.Yj
Geometryi.Aj

 

visRowVertex + j

visX
visY
visSplineKnot

InfiniteLine row
(in Geometryisection)

Geometryi.X1
Geometryi.Y1
Geometryi.A1
Geometryi.B1

 

visRowVertex

visInfiniteLineX1
visInfiniteLineY1
visInfiniteLineX2
visInfiniteLineY2

Ellipse row
(in Geometryisection)

Geometryi.X1
Geometryi.Y1
Geometryi.A1
Geometryi.B1
Geometryi.C1
Geometryi.D1

 

visRowVertex

visEllipseCenterX
visEllipseCenterY
visEllipseMajorX
visEllipseMajorY
visEllipseMinorX
visEllipseMinorY

Glue Info section

GlueType
WalkPreference
BegTrigger
EndTrigger

visSectionObject

visRowMisc

visGlueType
visWalkPref
visBegTrigger
visEndTrigger

Group Properties section12

SelectMode
DisplayMode
IsTextEditTarget
IsSnapTarget
IsDropTarget
DontMoveChildren

visSectionObject

visRowGroup

visGroupSelectMode
visGroupDisplayMode
visGroupIsTextEditTarget
visGroupIsSnapTarget
visGroupIsDropTarget
visGroupDontMoveChildren

HyperLinks section

Hyperlink.Name.Description
Hyperlink.Name.Address
Hyperlink.Name.SubAddress
Hyperlink.Name.ExtraInfo
Hyperlink.Name.Frame
Hyperlink.Name.NewWindow
Hyperlink.Name.Default

visSectionHyperlink

visRow1stHyperlink +i

visHLinkDescription
visHLinkAddress
visHLinkSubAddress
visHLinkExtraInfo
visHLinkFrame
visHLinkNewWin
visHLinkDefault

Image Properties section13

Contrast
Brightness
Gamma
Blur
Sharpen
Denoise
Transparency

visSectionObject

visRowImage

visImageContrast
visImageBrightness
visImageGamma
visImageBlur
visImageSharpen
visImageDenoise
visImageTransparency

Layer Membership section

LayerMember

visSectionObject

visRowLayerMem

visLayerMember

Line Format section

LineWeight
LineColor
LinePattern
BeginArrow
EndArrow
LineCap
BeginArrowSize
EndArrowSize
Rounding
LineColorTrans

visSectionObject

visRowLine

visLineWeight
visLineColor
visLinePattern
visLineBeginArrow
visLineEndArrow
visLineEndCap
visLineBeginArrowSize
visLineEndArrowSize
visLineRounding
visLineColorTrans

Miscellaneous section

NoObjHandles
NonPrinting
NoCtlHandles
NoAlignBox
UpdateAlignBox
HideText
ObjType
DynFeedback
NoLiveDynamic
IsDropSource
Comment

visSectionObject

visRowMisc

visNoObjHandles
visNonPrinting
visNoCtlHandles
visNoAlignBox
visUpdateAlignBox
visHideText
visLOFlags
visDynFeedback
visNoLiveDynamics
visDropSource
visComment

Paragraph section

Para.IndFirst[i]
Para.IndLeft[i]
Para.IndRight[i]
Para.SpLine[i]
Para.SpBefore[i]
Para.SpAfter[i]
Para.HorzAlign[i]
Para.Bullet[i]
Para.BulletStr[i]

visSectionParagraph

visRowParagraph + i

visIndentFirst
visIndentLeft
visIndentRight
visSpaceLine
visSpaceBefore
visSpaceAfter
visHorzAlign
visBulletIndex
visBulletString

Protection section

LockWidth
LockHeight
LockMoveX
LockMoveY
LockAspect
LockDelete
LockBegin
LockEnd
LockRotate
LockCrop
LockVtxEdit
LockTextEdit
LockFormat
LockGroup
LockCalcWH
LockSelect

visSectionObject

visRowLock

visLockWidth
visLockHeight
visLockMoveX
visLockMoveY
visLockAspect
visLockDelete
visLockBegin
visLockEnd
visLockRotate
visLockCrop
visLockVtxEdit
visLockTextEdit
visLockFormat
visLockGroup
visLockCalcWH
visLockSelect

Scratch section

Scratch.Xi
Scratch.Yi
Scratch.Ai
Scratch.Bi
Scratch.Ci
Scratch.Di

visSectionScratch

visRowScratch + i

visScratchX
visScratchY
visScratchA
visScratchB
visScratchC
visScratchD

Shape Layout section

ShapePermeableX
ShapePermeableY
ShapePermeablePlace
ShapeFixedCode
ShapePlowCode
ShapeRouteStyle
ConLineJumpDirX
ConLineJumpDirY
ConFixedCode
ConLineJumpCode
ConLineJumpStyle
ShapePlaceFlip
ConLineRouteExt

visSectionObject

visRowShapeLayout

visSLOPermX
visSLOPermY
visSLOPermeablePlace
visSLOFixedCode
visSLOPlowCode
visSLORouteSyle
visSLOJumpDirX
visSLOJumpDirY
visSLOConFixedCode
visSLOJumpCode
visSLOJumpStyle
visSLOPlaceFlip
visSLOLineRouteExt

Shape Transform section

PinX
PinY
Width
Height
LocPinX
LocPinY
Angle
FlipX
FlipY
ResizeMode

visSectionObject

visRowXFormOut

visXFormPinX
visXFormPinY
visXFormWidth
visXFormHeight
visXFormLocPinX
visXFormLocPinY
visXFormAngle
visXFormFlipX
visXFormFlipY
visXFormResizeMode

Tabs section

Tabs.ci14
Tabs.ci14

visSectionTab

visRowTab + i

visTabStopCount5
(j*3) + visTabPos15
(j*3) + visTabAlign15

Text Block Format section

VerticalAlign
TopMargin
BottomMargin
LeftMargin
RightMargin
TextBkgnd
TextDirection
DefaultTabStop
TextBkgndTrans

visSectionObject

visRowText

visTxtBlkVerticalAlign
visTxtBlkTopMargin
visTxtBlkBottomMargin
visTxtBlkLeftMargin
visTxtBlkRightMargin
visTxtBlkBkgnd
visTxtBlkDirection
visTxtBlkDefaultTabStop
visTxtBlkBkgndTrans

Text Fields section16

Fields.Type[i]
Fields.Format[i]
Fields.Value[i]
Fields.EditMode[i]
Fields.UICat[i]
Fields.UICod[i]
Fields.UIFmt[i]

visSectionTextField

visRowField + i

visFieldType
visFieldFormat
visFieldCell
visFieldEditMode
visFieldUICategory
visFieldUICode
visFieldUIFormat

Text Transform section

TxtPinX
TxtPinY
TxtWidth
TxtHeight
TxtLocPinX
TxtLocPinY
TxtAngle

visSectionObject

visRowTextXForm

visXFormPinX
visXFormPinY
visXFormWidth
visXFormHeight
visXFormLocPinX
visXFormLocPinY
visXFormAngle

User-Defined Cells section

User.Name.Value9
User.Name.Prompt

visSectionUser

visRowUser + i

visUserValue
visUserPrompt

 

REF:http://www.helpdoc-online.com/Microsoft_Visio_2002_Developing_Solutions_en/Section_Row_and_Cell_Indices_Shapes.htm

VBA学习笔记(4)-Section, Row, and Cell Indices for Shapes