Public Sub SetFlexGridRowBackColor(cFlexGrid As MSHFlexGrid, oCellColorFirst As Long, oCellColorNext As Long)
Dim K As Long
Dim l As Long
Dim oCounterCols As Long
Dim oCounterRows As LongWith cFlexGrid
oCounterCols = .Cols - 1
oCounterRows = .Rows - 1
.Redraw = False
For K = 0 + .FixedRows To oCounterRows
For l = 0 + .FixedCols To oCounterCols
.Row = K
.Col = l
If (K + .FixedRows) Mod 2 = 0 Then
.CellBackColor = oCellColorFirst
Else
.CellBackColor = oCellColorNext
End If
Next l
Next K
.Redraw = True
End WithEnd Sub
调用:SetFlexGridRowBackColor msflexgrid, vbWhite, vbYellow 我从vbprobe来,在那也是我的发言,改一下就可,这分我是要定啊
Dim K As Long
Dim l As Long
Dim oCounterCols As Long
Dim oCounterRows As LongWith cFlexGrid
oCounterCols = .Cols - 1
oCounterRows = .Rows - 1
.Redraw = False
For K = 0 + .FixedRows To oCounterRows
For l = 0 + .FixedCols To oCounterCols
.Row = K
.Col = l
If (K + .FixedRows) Mod 2 = 0 Then
.CellBackColor = oCellColorFirst
Else
.CellBackColor = oCellColorNext
End If
Next l
Next K
.Redraw = True
End WithEnd Sub
调用:SetFlexGridRowBackColor msflexgrid, vbWhite, vbYellow 我从vbprobe来,在那也是我的发言,改一下就可,这分我是要定啊
解决方案 »
- --------------------------------------------------------------VB网页自动填表,下拉列表问题!
- 在webbrowser如何获得用鼠标指向某图片时出现的内容
- 用到ActiveSkin4.3时碰到这样一个问题:VB窗体中所有字体全部自己变形了,能交流一下吗?
- 如何在另一个程序上显示文字
- sql数据库被更改后,如何触发事件来自动与它绑定的excel表格里的数据?
- Open "LPT1" For Output As #1 导致程序死掉的问题!(100分求救)
- 急需!!!!设计一个小程序!在线等!!
- 如何用VB通过代码,把Excel文件里数据导入到SQLserver?(谢谢,各位)
- 求助股票预警软件思路,请大家帮帮忙
- 熟悉VBA的朋友进来帮我看看,为什么绝对路径可以,不相对路径不行,我在EXCEL中写VBA,我用ACCESS数据库。
- 我终于明白VB程序员是SB的道理了!!!!
- ado与odbc的问题
Me.MSHFlexGrid1.Col = 4
'i为行号,如果有标题行i=1,否则为0
For i = 1 To Me.MSHFlexGrid1.Rows - 1
Me.MSHFlexGrid1.Row = i
If CLng(Me.MSHFlexGrid1.Text) > 0 Then
Me.MSHFlexGrid1.CellForeColor = vbBlue
End If
Next i
Dim K As Long
Dim l As Long
Dim oCounterCols As Long
Dim oCounterRows As LongWith cFlexGrid
oCounterCols = .Cols - 1
oCounterRows = .Rows - 1
.Redraw = False
For K = 0 + .FixedRows To oCounterRows
For l = 0 + .FixedCols To oCounterCols
.Row = K
.Col = l
If (l + .FixedCols) Mod 2 = 0 Then
.CellBackColor = oCellColorFirst
Else
.CellBackColor = oCellColorNext
End If
Next l
Next K
.Redraw = True
End WithEnd Sub
SetFlexGridColBackColor msflexgrid, vbblue, vbYellow改改应该就可以啦
'第四列
Me.MSHFlexGrid1.Col = 4
'i为行号,如果有标题行i=1,否则为0
For i = 1 To Me.MSHFlexGrid1.Rows - 1
Me.MSHFlexGrid1.Row = i
If CLng(Me.MSHFlexGrid1.Text) >= 0 Then
Me.MSHFlexGrid1.CellForeColor = vbBlue
Else
Me.MSHFlexGrid1.CellForeColor = vbGreen
End If
Next i
'第四列
Me.MSHFlexGrid1.Col = 4
'i为行号,如果有标题行i=1,否则为0
For i = 1 To Me.MSHFlexGrid1.Rows - 1
Me.MSHFlexGrid1.Row = i
Me.MSHFlexGrid1.CellForeColor = Iif(CLng(Me.MSHFlexGrid1.Text) >= 0,vbBlue,vbGreen)
Next i