1,451
社区成员
发帖
与我相关
我的任务
分享
Dim a() As String
a = Split("8,10,12,14,15,16", ",")
With MSFlexGrid1 '改变列的背景色
For K = 0 To UBound(a)
.Col = a(i)
For J = 1 To .Rows - 1
.Row = J
.CellBackColor = &HFEFBDE '改变背景色
Next J
Next K
End With
With MSFlexGrid1
.Redraw = False'这个可以快一点
.FillStyle = flexFillRepeat '设置这个属性,一次改变一行、一列
For k = 1 To .Cols - 1
If k = 8 Or k = 10 Or k = 12 Or k = 14 Or k = 15 Or k = 16 Then
.Col = k
.Row = 1
.RowSel = .Rows - 1
.CellBackColor = &HFEFBDE '改变背景色
End If
Next k
.Redraw = True
End With
Private Sub Command1_Click()
Dim a() As String
Dim K As Integer
Dim J As Integer
a = Split("8,10,12,14,15,16", ",")
With MSFlexGrid1 '改变列的背景色
For K = 0 To UBound(a)
.Col = a(K)
For J = 1 To .Rows - 1
.Row = J
.CellBackColor = &HFEFBDE '改变背景色
Next J
Next K
End With
End Sub