先放好一个picture,把它的index设0 然后 Private Sub Form_Load() Dim i As Integer Dim j As Integer
MSFlexGrid1.Rows = 39 MSFlexGrid1.Cols = 7
For i = 1 To 38 For j = 1 To 6 MSFlexGrid1.TextMatrix(i, j) = i & " " & j Next j Next i
For i = 1 To 25 Load Picture1(i) Picture1(i).Left = Picture1(0).Left Picture1(i).Top = Picture1(0).Top + i * (MSFlexGrid1.CellHeight + 15) Picture1(i).Visible = True Picture1(i).ZOrder (0) Next i
End Sub
Private Sub Form_Load() Dim i As Integer Dim j As Integer
MSFlexGrid1.Rows = 39 MSFlexGrid1.Cols = 7
For i = 1 To 38 For j = 1 To 6 MSFlexGrid1.TextMatrix(i, j) = i & " " & j Next j Next i
For i = 1 To 25 '要根据你显示的行数来确定 Load Picture1(i) Picture1(i).Left = Picture1(0).Left Picture1(i).Top = Picture1(0).Top + i * (MSFlexGrid1.CellHeight + 15) Picture1(i).Visible = True Picture1(i).ZOrder (0) Next i
End Sub
隔行变色 With MS1 .FillStyle = 1 For I = 1 To .Rows-1 .Row = I .Col = 0 .ColSel = .Cols-1 If I Mod 2 = 0 Then '偶数行 .CellForeColor = "&H" & Hex(XXX) .CellBackColor = "&H" & Hex(XXX) Else '奇数行 .CellForeColor = "&H" & Hex(XXX) .CellBackColor = "&H" & Hex(XXX) End If Next I .FillStyle = 0 .Row = 0 .Col = 0 End With
自动化程度高一些 Private Sub Form_Load() Dim i As Integer Dim j As Integer
MSFlexGrid1.Rows = 39 MSFlexGrid1.Cols = 7
For i = 1 To 38 For j = 1 To 6 MSFlexGrid1.TextMatrix(i, j) = i & " " & j Next j Next i
然后
Private Sub Form_Load()
Dim i As Integer
Dim j As Integer
MSFlexGrid1.Rows = 39
MSFlexGrid1.Cols = 7
For i = 1 To 38
For j = 1 To 6
MSFlexGrid1.TextMatrix(i, j) = i & " " & j
Next j
Next i
For i = 1 To 25
Load Picture1(i)
Picture1(i).Left = Picture1(0).Left
Picture1(i).Top = Picture1(0).Top + i * (MSFlexGrid1.CellHeight + 15)
Picture1(i).Visible = True
Picture1(i).ZOrder (0)
Next i
End Sub
Dim i As Integer
Dim j As Integer
MSFlexGrid1.Rows = 39
MSFlexGrid1.Cols = 7
For i = 1 To 38
For j = 1 To 6
MSFlexGrid1.TextMatrix(i, j) = i & " " & j
Next j
Next i
For i = 1 To 25 '要根据你显示的行数来确定
Load Picture1(i)
Picture1(i).Left = Picture1(0).Left
Picture1(i).Top = Picture1(0).Top + i * (MSFlexGrid1.CellHeight + 15)
Picture1(i).Visible = True
Picture1(i).ZOrder (0)
Next i
End Sub
With MS1
.FillStyle = 1 For I = 1 To .Rows-1
.Row = I
.Col = 0
.ColSel = .Cols-1
If I Mod 2 = 0 Then '偶数行
.CellForeColor = "&H" & Hex(XXX)
.CellBackColor = "&H" & Hex(XXX)
Else '奇数行
.CellForeColor = "&H" & Hex(XXX)
.CellBackColor = "&H" & Hex(XXX)
End If
Next I .FillStyle = 0
.Row = 0
.Col = 0
End With
Private Sub Form_Load()
Dim i As Integer
Dim j As Integer
MSFlexGrid1.Rows = 39
MSFlexGrid1.Cols = 7
For i = 1 To 38
For j = 1 To 6
MSFlexGrid1.TextMatrix(i, j) = i & " " & j
Next j
Next i
Picture1(0).Left = MSFlexGrid1.Left + 45
Picture1(0).Top = MSFlexGrid1.Top + MSFlexGrid1.CellHeight + 45
Picture1(0).Width = MSFlexGrid1.Width - 500
Picture1(0).Height = 15
Picture1(0).BackColor = vbRed
i = 0
Do
i = i + 1
Load Picture1(i)
Picture1(i).Left = Picture1(0).Left
Picture1(i).Top = Picture1(0).Top + i * (MSFlexGrid1.CellHeight + 15)
Picture1(i).Visible = True
Picture1(i).ZOrder (0)
Loop Until 60 + (i + 2) * (MSFlexGrid1.CellHeight + 15) >= MSFlexGrid1.Height
End Sub