Обводка ячеек Flex Grid

[Vitaly1]

В Екселе на форме стоит Flex Grid можноли cделать обводку снизу ячеек каждой четной строки?

[Vitaly1]

Господа, если нельзя задать обводку отдельных ячеек Flex Grid, ответьте пожалусто, кто знает. Нельзя?

[RayShade]

Ну нельзя, нельзя! Написано же ведь:





Visual Basic: MSFlexGrid/MSHFlexGrid Controls



GridLines, GridLinesBand, GridLinesFixed, GridLinesHeader, GridLinesIndent, GridLinesUnpopulated Properties (MSHFlexGrid)



Returns or sets a value that determines whether lines are drawn between cells, bands, headers, indents, or unpopulated areas. These properties also determine the type of lines that are drawn in the MSHFlexGrid.



Note If using the MSFlexGrid, only the GridLines and GridLinesFixed properties are available.



Syntax



object.GridLines [= value]

object.GridLinesBand(BandNumber) [= value]

object.GridLinesFixed [= value]

object.GridLinesHeader(BandNumber) [= value]

object.GridLinesIndent(BandNumber) [= value]

object.GridLinesUnpopulated [= value]



Syntax for the GridLines, GridLinesBand, GridLinesFixed, GridLinesHeader, GridLinesIndent, and GridLinesUnpopulated properties has these parts:



Part Description

object An object expression that evaluates to an object in the Applies To list.

BandNumber Required. A Long value that specifies the band being affected.

value An integer or constant that specifies the type of lines drawn, as described in Settings.





Settings



The settings for value are:



Constant Value Description

flexGridNone 0 There are no lines between cells. In the MSFlexGrid, this is the default for GridLines.

flexGridFlat 1 The line style between cells is set to normal, flat, lines. In the MSHFlexGrid, this is the default for GridLines.

flexGridInset 2 The line style between cells is set to inset lines. In the MSFlexGrid, this is the default for GridLinesFixed.

flexGridRaised 3 The line style between cells is set to raised lines. In the MSHFlexGrid, this is the default for GridLinesFixed.

flexGridDashes 4 The line style between cells is set to dashed lines.

flexGridDots 5 The line style between cells is set to dotted lines.





Remarks



When the GridLines property is set to 1 (Lines), the color of the lines is determined by the GridColor property.



Raised and inset gridlines are always black and white.



Как ясно из вышенаписанного, эти проперти ГЛОБАЛЬНО вляиют на весь grid.

[Vitaly1]

Фирштейн,
спасибо! А жаль, что нельзя