Cells, Text and Appearance
The 25 enumerations that the topic pages Rows and Columns, Sizes and Positions, Cell Text, Cell Formatting, Merging Cells and Appearance of the VBFlexGrid control use are listed here in alphabetical order. Every enumeration is declared inside the control, and its members are written without a qualifier or with the name of the enumeration, as in FlexAlignmentLeftTop or FlexAlignmentConstants.FlexAlignmentLeftTop.
- FlexAlignmentConstants
- FlexAllowUserFreezingConstants
- FlexAllowUserResizingConstants
- FlexAutoSizeModeConstants
- FlexAutoSizeScopeConstants
- FlexBestFitModeConstants
- FlexBorderStyleConstants
- FlexCellSettings
- FlexClearWhatConstants
- FlexClearWhereConstants
- FlexEllipsisFormatConstants
- FlexFillStyleConstants
- FlexFontQualityConstants
- FlexGridLineConstants
- FlexLookupConvConstants
- FlexMergeCellsConstants
- FlexMetricConstants
- FlexMimicTextBoxConstants
- FlexPictureAlignmentConstants
- FlexPictureTypeConstants
- FlexRightToLeftModeConstants
- FlexRowSizingModeConstants
- FlexTextStyleConstants
- FlexWallPaperAlignmentConstants
- FlexWordWrapOptions
FlexAlignmentConstants
The alignment of text in a cell: a horizontal position (left, center, right or general) combined with a vertical one (top, center or bottom). It is used by the CellAlignment, ColAlignment and FixedAlignment properties.
The members whose names start with FlexAlignmentGeneral choose the horizontal position of each cell from its text. Text that IsNumeric or IsDate accepts is aligned to the right, any other text to the left. The MirrorAlignGeneral property reverses that choice, which suits right-to-left reading order.
FixedAlignment also accepts -1, which is not a member: the fixed cells of the column then use ColAlignment. CellAlignment accepts -1 as well: the cell then uses the alignment of its column. FlexAlignmentGeneral is the alignment of a column that no code has set.
| Member | Value | Description |
|---|---|---|
| FlexAlignmentLeftTop | 0 | Left, at the top of the cell. |
| FlexAlignmentLeftCenter | 1 | Left, centered vertically. |
| FlexAlignmentLeftBottom | 2 | Left, at the bottom of the cell. |
| FlexAlignmentCenterTop | 3 | Centered horizontally, at the top. |
| FlexAlignmentCenterCenter | 4 | Centered horizontally and vertically. |
| FlexAlignmentCenterBottom | 5 | Centered horizontally, at the bottom. |
| FlexAlignmentRightTop | 6 | Right, at the top of the cell. |
| FlexAlignmentRightCenter | 7 | Right, centered vertically. |
| FlexAlignmentRightBottom | 8 | Right, at the bottom of the cell. |
| FlexAlignmentGeneral | 9 | General: numbers and dates to the right, other text to the left, centered vertically. |
| FlexAlignmentGeneralTop | 10 | General horizontally, at the top of the cell. |
| FlexAlignmentGeneralCenter | 11 | General horizontally, centered vertically. It does the same as FlexAlignmentGeneral. |
| FlexAlignmentGeneralBottom | 12 | General horizontally, at the bottom of the cell. |
FlexAllowUserFreezingConstants
Which kinds of rows and columns the user can freeze with the mouse. It is used by the AllowUserFreezing property.
The values are bits: 1 stands for columns and 2 for rows, and FlexAllowUserFreezingBoth is their sum.
| Member | Value | Description |
|---|---|---|
| FlexAllowUserFreezingNone | 0 | The user cannot freeze rows or columns. |
| FlexAllowUserFreezingColumns | 1 | The user can freeze columns. |
| FlexAllowUserFreezingRows | 2 | The user can freeze rows. |
| FlexAllowUserFreezingBoth | 3 | The user can freeze rows and columns. |
FlexAllowUserResizingConstants
Which kinds of dividers the user can drag to resize columns and rows. It is used by the AllowUserResizing property.
The values are bits: 1 stands for columns and 2 for rows, and FlexAllowUserResizingBoth is their sum.
| Member | Value | Description |
|---|---|---|
| FlexAllowUserResizingNone | 0 | The user cannot resize rows or columns. |
| FlexAllowUserResizingColumns | 1 | The user can resize columns. |
| FlexAllowUserResizingRows | 2 | The user can resize rows. |
| FlexAllowUserResizingBoth | 3 | The user can resize rows and columns. |
FlexAutoSizeModeConstants
What the AutoSize method resizes: column widths or row heights.
| Member | Value | Description |
|---|---|---|
| FlexAutoSizeModeColWidth | 0 | Sets the widths of the columns the method names. The scope chooses which rows it measures. |
| FlexAutoSizeModeRowHeight | 1 | Sets the heights of the rows the method names. The scope chooses which columns it measures. |
FlexAutoSizeScopeConstants
Which cells the AutoSize method measures when it sets a column width or a row height.
In column mode (FlexAutoSizeModeConstants) the scope selects rows, and in row mode it selects columns. The description of each member names the rows; the columns follow the same rule.
| Member | Value | Description |
|---|---|---|
| FlexAutoSizeScopeAll | 0 | All rows. |
| FlexAutoSizeScopeFixed | 1 | The fixed rows only. |
| FlexAutoSizeScopeScrollable | 2 | The rows after the fixed rows and the frozen rows, which scroll. |
| FlexAutoSizeScopeMovable | 3 | The frozen rows and the scrollable rows, which together are every row after the fixed rows. |
| FlexAutoSizeScopeFrozen | 4 | The frozen rows only. |
FlexBestFitModeConstants
What AutoSize and the format string count besides the text when they compute the best size of a cell. It is used by the BestFitMode property.
The cell contents that the modes add are the combo cue, a picture aligned with one of the no-overlap alignments, a check box aligned at the left or the right of the cell, and the sort arrow in the fixed row that RowSortArrows names.
| Member | Value | Description |
|---|---|---|
| FlexBestFitModeTextOnly | 0 | Only the text counts. This is the default. |
| FlexBestFitModeFull | 1 | The text, the combo cue, the picture, the check box and the sort arrow. |
| FlexBestFitModeSortArrowText | 2 | The text and the sort arrow. |
| FlexBestFitModeOtherText | 3 | The text, the combo cue, the picture and the check box, but not the sort arrow. |
FlexBorderStyleConstants
The border around the control. It is used by the BorderStyle property.
The members select Windows window border styles.
| Member | Value | Description |
|---|---|---|
| FlexBorderStyleNone | 0 | No border. |
| FlexBorderStyleSingle | 1 | A thin single-line border. |
| FlexBorderStyleThin | 2 | A thin three-dimensional border (the static edge style). |
| FlexBorderStyleSunken | 3 | A sunken border (the client edge style). This is the default. |
| FlexBorderStyleRaised | 4 | A raised border (the window edge style with a dialog frame). |
FlexCellSettings
The cell settings that the Cell property reads and writes for any cell or range of cells, without selecting it.
Each member names the cell property whose value the Cell property reads or writes. For most members, a range of cells (the RowSel and ColSel arguments) gets the same value in every cell, as when FillStyle is FlexFillStyleRepeat.
A member that cannot be read or cannot be written raises an error: FlexCellSort raises 394 when read, and FlexCellLeft, FlexCellTop, FlexCellWidth, FlexCellHeight, FlexCellTextDisplay and FlexCellTextHidden raise 383 when written. A value that is not a member raises 380. FlexCellPicture and FlexCellTag are the two members that accept an object, which is assigned with Set.
| Member | Value | Description |
|---|---|---|
| FlexCellText | 0 | The text of the cell: Text. |
| FlexCellClip | 1 | The contents of the cells as a clip string: Clip. |
| FlexCellTextStyle | 2 | The 3D effect of the text: CellTextStyle. |
| FlexCellAlignment | 3 | The alignment of the text: CellAlignment. |
| FlexCellPicture | 4 | The picture of the cell: CellPicture. |
| FlexCellPictureAlignment | 5 | The alignment of the picture: CellPictureAlignment. |
| FlexCellBackColor | 6 | The background color: CellBackColor. |
| FlexCellForeColor | 7 | The text color: CellForeColor. |
| FlexCellToolTipText | 8 | The tool tip of the cell: CellToolTipText. |
| FlexCellComboCue | 9 | The combo cue of the cell: CellComboCue. |
| FlexCellChecked | 10 | The check box state: CellChecked. |
| FlexCellFloodPercent | 11 | The percentage of the cell that the flood bar fills, from -100 to 100; a negative value fills the cell from the right: CellFloodPercent. |
| FlexCellFloodColor | 12 | The color of the flood bar: CellFloodColor. |
| FlexCellFontName | 13 | The font name: CellFontName. |
| FlexCellFontSize | 14 | The font size: CellFontSize. |
| FlexCellFontBold | 15 | The bold attribute: CellFontBold. |
| FlexCellFontItalic | 16 | The italic attribute: CellFontItalic. |
| FlexCellFontStrikeThrough | 17 | The strikethrough attribute: CellFontStrikeThrough. |
| FlexCellFontUnderline | 18 | The underline attribute: CellFontUnderline. |
| FlexCellFontCharset | 19 | The font character set: CellFontCharset. |
| FlexCellLeft | 20 | The left edge of the cell: CellLeft. Read-only. |
| FlexCellTop | 21 | The top edge of the cell: CellTop. Read-only. |
| FlexCellWidth | 22 | The width of the cell: CellWidth. Read-only. |
| FlexCellHeight | 23 | The height of the cell: CellHeight. Read-only. |
| FlexCellSort | 24 | Sorts the rows by the column of the cell or range, with the sort order that is written: Sort. Write-only. |
| FlexCellTextDisplay | 25 | The text as the cell displays it, after the column’s lookup and format string are applied. Read-only. |
| FlexCellTextHidden | 26 | True when the cell does not draw its text, because an image of the column’s image list is drawn instead or because the text stands for a check box (FlexTextAsCheckBox). Read-only. |
| FlexCellHasCustomFormatting | 27 | Whether the cell has memory allocated for custom formatting: CellHasCustomFormatting. Writing False frees it. |
| FlexCellHasTag | 28 | Whether the cell has memory allocated for a tag: CellHasTag. Writing False frees it. |
| FlexCellTag | 29 | The tag of the cell: CellTag. |
Writing and reading settings of cells that are not the current cell, and the errors that read-only and write-only members raise:
With VBFlexGrid1
.Rows = 3
.Cols = 3
.Cell(FlexCellText, 1, 1) = "x"
Debug.Print .TextMatrix(1, 1) ' x
.Cell(FlexCellText, 1, 1, 2, 2) = "z"
Debug.Print .TextMatrix(1, 2); .TextMatrix(2, 1); .TextMatrix(2, 2) ' zzz
On Error Resume Next
.Cell(FlexCellWidth, 1, 1) = 100
Debug.Print Err.Number ' 383
Err.Clear
Debug.Print .Cell(FlexCellSort, 1, 1)
Debug.Print Err.Number ' 394
End With
FlexClearWhatConstants
What the Clear method clears in the cells that the area names.
| Member | Value | Description |
|---|---|---|
| FlexClearEverything | 0 | The text, the formatting and the tag. A grid with a custom data source (FlexDataSource) raises error 5 for this member. |
| FlexClearText | 1 | The text only. |
| FlexClearFormatting | 2 | The cell formatting only (colors, fonts, alignment, picture, flood bar, tool tip, combo cue and check box state). It frees the memory that formatting uses. |
| FlexClearTag | 3 | The tag only. It frees the memory that tags use. |
FlexClearWhereConstants
The area of the grid that the Clear method clears.
| Member | Value | Description |
|---|---|---|
| FlexClearEverywhere | 0 | All cells. |
| FlexClearFixed | 1 | The fixed rows and the fixed columns. |
| FlexClearScrollable | 2 | The cells after the fixed and the frozen rows and columns, which scroll. |
| FlexClearMovable | 3 | The frozen and the scrollable cells, which together are every cell after the fixed rows and columns. |
| FlexClearFrozen | 4 | The frozen rows and columns. |
| FlexClearSelection | 5 | The selected cells. |
| FlexClearClip | 6 | The cells of the selection. When ClipPasteMode is FlexClipPasteModeExtended or higher, the selection is extended to whole rows in FlexSelectionModeFreeByRow and to whole columns in FlexSelectionModeFreeByColumn, and with AllowMultiSelection every selected row is cleared. The Delete method uses it. |
FlexEllipsisFormatConstants
How text that does not fit in its cell is shortened with an ellipsis. It is used by the EllipsisFormat and EllipsisFormatFixed properties.
For a column that has not set its own ColWordWrapOption, the setting is one of the three, with WordWrap and SingleLine, from which the column’s member of FlexWordWrapOptions is made. The members are the Windows text formats of the same names.
| Member | Value | Description |
|---|---|---|
| FlexEllipsisFormatNone | 0 | No ellipsis. This is the default. |
| FlexEllipsisFormatEnd | 1 | The text is cut at the end and finished with an ellipsis. |
| FlexEllipsisFormatPath | 2 | The ellipsis replaces characters in the middle, so that the end of a path stays visible. |
| FlexEllipsisFormatWord | 3 | A word that does not fit is cut and finished with an ellipsis. |
FlexFillStyleConstants
Whether setting a cell property applies to the current cell or to every selected cell. It is used by the FillStyle property.
The Cell property sets this value itself while it works, to FlexFillStyleRepeat for a range and to FlexFillStyleSingle for one cell, and restores it afterwards.
| Member | Value | Description |
|---|---|---|
| FlexFillStyleSingle | 0 | Only the current cell changes. This is the default. |
| FlexFillStyleRepeat | 1 | Every selected cell changes. |
FlexFontQualityConstants
How the fonts of the grid are rendered. The members have the values of the Windows font qualities. It is used by the FontQuality property.
| Member | Value | Description |
|---|---|---|
| FlexFontQualityDefault | 0 | Windows chooses. This is the default. |
| FlexFontQualityDraft | 1 | Draft quality: appearance matters less than with proof quality. |
| FlexFontQualityProof | 2 | Proof quality: the exactness of the character shapes matters more than the exactness of the size. |
| FlexFontQualityNonAntiAliased | 3 | Text is never smoothed. |
| FlexFontQualityAntiAliased | 4 | Text is smoothed when the font and size support it. |
| FlexFontQualityClearType | 5 | Text is smoothed with ClearType. |
| FlexFontQualityClearTypeNatural | 6 | Text is smoothed with natural ClearType, which keeps the character shapes closer to the font. |
FlexGridLineConstants
The type of the lines between cells, and whether they run in both directions or in one only. It is used by the GridLines, GridLinesFixed and GridLinesFrozen properties.
The members without a suffix draw horizontal and vertical lines, the members ending in Horz only horizontal ones, and those ending in Vert only vertical ones. Flat, dashed and dotted lines have the color of the matching grid color property. The inset and raised lines are drawn in two colors, black and white, to look sunken or raised, and ignore the color property. The default is FlexGridLineFlat for the scrollable and the frozen cells and FlexGridLineInset for the fixed cells.
| Member | Value | Description |
|---|---|---|
| FlexGridLineNone | 0 | No lines. |
| FlexGridLineFlat | 1 | Solid lines. |
| FlexGridLineInset | 2 | Sunken lines. |
| FlexGridLineRaised | 3 | Raised lines. |
| FlexGridLineDashes | 4 | Dashed lines. |
| FlexGridLineDots | 5 | Dotted lines. |
| FlexGridLineFlatHorz | 6 | Solid horizontal lines. |
| FlexGridLineInsetHorz | 7 | Sunken horizontal lines. |
| FlexGridLineRaisedHorz | 8 | Raised horizontal lines. |
| FlexGridLineDashesHorz | 9 | Dashed horizontal lines. |
| FlexGridLineDotsHorz | 10 | Dotted horizontal lines. |
| FlexGridLineFlatVert | 11 | Solid vertical lines. |
| FlexGridLineInsetVert | 12 | Sunken vertical lines. |
| FlexGridLineRaisedVert | 13 | Raised vertical lines. |
| FlexGridLineDashesVert | 14 | Dashed vertical lines. |
| FlexGridLineDotsVert | 15 | Dotted vertical lines. |

FlexLookupConvConstants
The direction of a lookup conversion that LookupConv makes.
A lookup maps keys, which a database stores, to values, which the user reads; ColLookup defines it for a column.
| Member | Value | Description |
|---|---|---|
| FlexLookupConvValue | 0 | Converts a key to its value. The key matches without regard to case. |
| FlexLookupConvKey | 1 | Converts a value to its key. The value matches exactly, with regard to case. |
Converting in both directions with a lookup of two entries:
With VBFlexGrid1
.ColLookup(1) = "1;One|2;Two"
Debug.Print .LookupConv("2", FlexLookupConvValue, 1) ' Two
Debug.Print .LookupConv("One", FlexLookupConvKey, 1) ' 1
End With
FlexMergeCellsConstants
Which neighbouring cells with the same content the grid merges into one. It is used by the MergeCells property.
Merging applies only to the rows and columns that MergeRow and MergeCol switch on. Cells in a row merge when each has the same content as its left neighbour, and cells in a column merge when each has the same content as its upper neighbour. In the restricted modes, two cells merge in one direction only if the cells beside them are equal as well, so that merged blocks look like a hierarchy: FlexMergeCellsRestrictRows restricts the merging within columns, and FlexMergeCellsRestrictColumns the merging within rows.
| Member | Value | Description |
|---|---|---|
| FlexMergeCellsNever | 0 | No merging. This is the default. |
| FlexMergeCellsFree | 1 | Merge within the rows and within the columns that are switched on. |
| FlexMergeCellsRestrictRows | 2 | Rows merge freely. Two cells of a column merge only if the cells to the left of them are equal too. |
| FlexMergeCellsRestrictColumns | 3 | Columns merge freely. Two cells of a row merge only if the cells above them are equal too. |
| FlexMergeCellsRestrictAll | 4 | Both restrictions: those of FlexMergeCellsRestrictRows and of FlexMergeCellsRestrictColumns. |
| FlexMergeCellsFixedOnly | 5 | Merge freely, but only the fixed rows and fixed columns. |

FlexMetricConstants
The size metric that GetMetrics returns.
GetMetrics returns the horizontal size in its CX argument and the vertical size in its CY argument, in twips. The control defines every metric except the size of a scroll bar, which comes from Windows, in device-independent pixels (the sizes in the descriptions) and converts them for the DPI of the display.
| Member | Value | Description |
|---|---|---|
| FlexMetricDividerSpacing | 0 | The distance from the edge of a cell within which a hit counts as on the divider (2 device-independent pixels in both directions). |
| FlexMetricTextPadding | 1 | The space between the edge of a cell and its text (3 device-independent pixels horizontally, 1 vertically). |
| FlexMetricCellSpacing | 2 | The space that AutoSize adds to the text size of the best fit (6 device-independent pixels horizontally, 3 vertically). |
| FlexMetricScrollBarSize | 3 | The size of a scroll bar, which is also the width of a drop-down arrow. |
| FlexMetricCheckBoxSize | 4 | The size of a check box (13 device-independent pixels in both directions). |
FlexMimicTextBoxConstants
Whether a column draws its text the way a multi-line text box does. It is used by the ColMimicTextBox and ColMimicTextBoxFixed properties.
Mimicking a text box draws the text with the Windows DT_EDITCONTROL format, as a multi-line text box draws it: the average character width is calculated as a text box calculates it, and a last line that would show only in part is left out. MimicTextBox is the setting for the whole grid, and the column properties accept -1 in addition, which is not a member and means the grid’s setting.
| Member | Value | Description |
|---|---|---|
| FlexMimicTextBoxOn | 0 | The column draws its text like a text box. |
| FlexMimicTextBoxOff | 1 | The column draws its text in the normal way. MimicTextBox is False by default. |
FlexPictureAlignmentConstants
Where the picture of a cell is drawn relative to the cell and to its text. It is used by the CellPictureAlignment property.
The nine positions place the picture over the cell, and the text is drawn over the picture. The NoOverlap members place the picture at the left or right edge and take the width it needs from the text area, so that the text and the picture do not cover each other; there is no centered no-overlap member, so the numbers 23 to 25 are not used. Best fit (BestFitMode) counts the width of a no-overlap picture.
| Member | Value | Description |
|---|---|---|
| FlexPictureAlignmentLeftTop | 0 | At the left, at the top of the cell. |
| FlexPictureAlignmentLeftCenter | 1 | At the left, centered vertically. |
| FlexPictureAlignmentLeftBottom | 2 | At the left, at the bottom of the cell. |
| FlexPictureAlignmentCenterTop | 3 | Centered horizontally, at the top. |
| FlexPictureAlignmentCenterCenter | 4 | Centered horizontally and vertically. |
| FlexPictureAlignmentCenterBottom | 5 | Centered horizontally, at the bottom. |
| FlexPictureAlignmentRightTop | 6 | At the right, at the top of the cell. |
| FlexPictureAlignmentRightCenter | 7 | At the right, centered vertically. |
| FlexPictureAlignmentRightBottom | 8 | At the right, at the bottom of the cell. |
| FlexPictureAlignmentStretch | 9 | Stretched to fill the cell. |
| FlexPictureAlignmentTile | 10 | Repeated to fill the cell. |
| FlexPictureAlignmentLeftTopNoOverlap | 20 | At the left, at the top, beside the text. |
| FlexPictureAlignmentLeftCenterNoOverlap | 21 | At the left, centered vertically, beside the text. |
| FlexPictureAlignmentLeftBottomNoOverlap | 22 | At the left, at the bottom, beside the text. |
| FlexPictureAlignmentRightTopNoOverlap | 26 | At the right, at the top, beside the text. |
| FlexPictureAlignmentRightCenterNoOverlap | 27 | At the right, centered vertically, beside the text. |
| FlexPictureAlignmentRightBottomNoOverlap | 28 | At the right, at the bottom, beside the text. |
FlexPictureTypeConstants
The kind of picture that the Picture property creates from the grid. It is used by the PictureType property.
The setting also decides how the grid renders itself for a page print (the VP_FORMATRANGE message).
| Member | Value | Description |
|---|---|---|
| FlexPictureTypeColor | 0 | A color bitmap. This is the default. |
| FlexPictureTypeMonochrome | 1 | A black and white bitmap. |
| FlexPictureTypeEnhMetafile | 2 | An enhanced metafile, which scales better when it is painted on a printer. |
FlexRightToLeftModeConstants
How the RightToLeft property decides whether the control reads and lays out from right to left. It is used by the RightToLeftMode property.
The setting matters only while RightToLeft is True. The three locale members then keep it True only when the chosen locale’s language reads from right to left; otherwise it turns False.
| Member | Value | Description |
|---|---|---|
| FlexRightToLeftModeNoControl | 0 | RightToLeft is used as set. |
| FlexRightToLeftModeVBAME | 1 | RightToLeft takes the value that the user control keeps after it is set, which is the behavior of the Middle East edition of VB and VBA. This is the default. |
| FlexRightToLeftModeSystemLocale | 2 | The system default locale decides. |
| FlexRightToLeftModeUserLocale | 3 | The default locale of the user decides. |
| FlexRightToLeftModeOSLanguage | 4 | The user interface language of Windows decides. |
FlexRowSizingModeConstants
What happens to the other rows when the user resizes one row with the mouse. It is used by the RowSizingMode property.
| Member | Value | Description |
|---|---|---|
| FlexRowSizingModeIndividual | 0 | Only the row that the user resizes changes. This is the default. |
| FlexRowSizingModeAll | 1 | Every row gets the new height. |
| FlexRowSizingModeUniform | 2 | The new height becomes RowHeightUniform, which applies to every row that has no height of its own. |
FlexTextStyleConstants
The 3D effect of the text in a cell. It is used by the CellTextStyle, TextStyle and TextStyleFixed properties.
The effects are made by drawing the text again, offset by one pixel, in gray or white. The raised and inset styles add a gray or white shadow, and the light styles add a white one only.
| Member | Value | Description |
|---|---|---|
| FlexTextStyleFlat | 0 | Plain text. This is the default. |
| FlexTextStyleRaised | 1 | Raised: a white highlight at the upper left and a gray shadow at the lower right. |
| FlexTextStyleInset | 2 | Sunken: a gray shadow at the upper left and a white highlight at the lower right. |
| FlexTextStyleRaisedLight | 3 | Raised, with the white highlight at the upper left only. |
| FlexTextStyleInsetLight | 4 | Sunken, with the white highlight at the lower right only. |

FlexWallPaperAlignmentConstants
Where the wallpaper picture is drawn in the area of the grid that is not fixed. It is used by the WallPaperAlignment property.
| Member | Value | Description |
|---|---|---|
| FlexWallPaperAlignmentLeftTop | 0 | At the upper left. |
| FlexWallPaperAlignmentLeftCenter | 1 | At the left, centered vertically. |
| FlexWallPaperAlignmentLeftBottom | 2 | At the lower left. |
| FlexWallPaperAlignmentCenterTop | 3 | Centered horizontally, at the top. |
| FlexWallPaperAlignmentCenterCenter | 4 | In the center. |
| FlexWallPaperAlignmentCenterBottom | 5 | Centered horizontally, at the bottom. |
| FlexWallPaperAlignmentRightTop | 6 | At the upper right. |
| FlexWallPaperAlignmentRightCenter | 7 | At the right, centered vertically. |
| FlexWallPaperAlignmentRightBottom | 8 | At the lower right. |
| FlexWallPaperAlignmentStretch | 9 | Stretched to fill the area. This is the default. |
| FlexWallPaperAlignmentTile | 10 | Repeated to fill the area. |
FlexWordWrapOptions
How a column breaks its text into lines and shortens text that does not fit. It is used by the ColWordWrapOption and ColWordWrapOptionFixed properties.
Each member combines up to two choices: word break or single line (not both), and an ellipsis format. FlexWordWrapNone means a plain draw that neither breaks words nor limits the text to one line, so the text breaks only at the line breaks it contains.
A column that has not set its own option reports the one that WordWrap, SingleLine and EllipsisFormat give together, so that reading ColWordWrapOption always returns a member. Writing -1, which is not a member, goes back to that. The fixed cells of the column have ColWordWrapOptionFixed in the same way.
| Member | Value | Description |
|---|---|---|
| FlexWordWrapNone | 0 | No word break, no single line, no ellipsis. |
| FlexWordBreak | 1 | Breaks the text into lines at words. |
| FlexSingleLine | 2 | Shows the text on one line and ignores line breaks. |
| FlexEndEllipsis | 3 | No word break; text that does not fit is cut at the end with an ellipsis. |
| FlexPathEllipsis | 4 | No word break; the ellipsis replaces characters in the middle, as for a path. |
| FlexWordEllipsis | 5 | No word break; a word that does not fit is cut with an ellipsis. |
| FlexWordBreakEndEllipsis | 6 | Word break, with an end ellipsis. |
| FlexWordBreakPathEllipsis | 7 | Word break, with a path ellipsis. |
| FlexWordBreakWordEllipsis | 8 | Word break, with a word ellipsis. |
| FlexSingleLineEndEllipsis | 9 | Single line, with an end ellipsis. |
| FlexSingleLinePathEllipsis | 10 | Single line, with a path ellipsis. |
| FlexSingleLineWordEllipsis | 11 | Single line, with a word ellipsis. |

A column that sets no option reports the combination of the grid’s properties:
With VBFlexGrid1
.WordWrap = True
.EllipsisFormat = FlexEllipsisFormatEnd
Debug.Print .ColWordWrapOption(0) = FlexWordBreakEndEllipsis ' True
.ColWordWrapOption(0) = FlexSingleLine
Debug.Print .ColWordWrapOption(0) ' 2
.ColWordWrapOption(0) = -1
Debug.Print .ColWordWrapOption(0) ' 6
End With