-
Grids and Colors
hi.. i was wondering how you would change a specific cell in a grid. Is it easier when using a datagrid, MSHFlexGrid or a MSFlexGrid.
I am creating a monitoring system for inventory and i want to be able to highlight the inventory that has no more stock left. Thanks.
-
Re: Grids and Colors
I d prefer the Flex Grid.
see this example
Code:
Private Sub Command1_Click()
Dim i As Integer
With MSFlexGrid1
For i = 0 To .Cols - 1
.Row = 3
.Col = i
.CellBackColor = vbRed
Next
For i = 0 To .Cols - 1
.Row = 1
.Col = i
.CellBackColor = vbCyan
Next
.Row = 2
.Col = 1
.CellBackColor = vbGreen
.Row = 4
.Col = 3
.CellBackColor = vbGreen
End With
End Sub
:wave: