Private Sub Command1_Click()
Dim I As Integer
MSFlexGrid1.Row = 2'设置第二行
For I = 0 To MSFlexGrid1.Cols - 1
MSFlexGrid1.Col = I
MSFlexGrid1.CellBackColor = vbYellow
MSFlexGrid1.CellForeColor = vbRed
Next I
End Sub
'给下午着色 --隔行着色应用实例
For Num = 1 To .Rows - 1 step 2
.Row = Num
.Col = 1
.RowSel = Num
.ColSel = .Cols - 1
.CellBackColor = Text4.BackColor
Next
'画假日、不存在日期单元格颜色 --根据条件,选定单位格范围着色
For Num = 1 To 31
Select Case varHoliday(Num)
Case 0
Case 1
.Col = Num
.Row = 1
.ColSel = Num
.RowSel = .Rows - 1
.CellBackColor = Text2.BackColor
Case 2
.Col = Num
.Row = 1
.ColSel = Num
.RowSel = .Rows - 1
.CellBackColor = Text3.BackColor
End Select
Next