dim i As integer
Dim nNum As long
for i=0 to Grid.rows-1
Grid.col=2
Grid.row=inNum=nNum+Grid.text'要保证为数值
next i
Grid.AddItem("")
grid.col=2
grid.row=i
grid.text=nNum
大概这样就行了
Dim nNum As long
for i=0 to Grid.rows-1
Grid.col=2
Grid.row=inNum=nNum+Grid.text'要保证为数值
next i
Grid.AddItem("")
grid.col=2
grid.row=i
grid.text=nNum
大概这样就行了
解决方案 »
- vb怎么打开桌面上的快捷方式
- webbrowser 控件VB6能用吗 在哪能下载此控件
- 如何设置进度条使得文件拷贝和进度条进度一致
- 请问adodc1.recordset.resync resync是什么意思呀?实现什么功能
- 在线等待!!!!!
- 为什么用mscomm和单片机通讯时收到乱码?如何改进?(另外还有两大难题,高手请指点)
- 哪位达人可以提供下输入一个URL 然后再一个框内反复提交验证码?
- vb6一个简单的固定内容字符串随机问题
- 关于在VB中使用Webbrowser的问题??急!!急!!
- 如何去掉VSFlexGrid运行时的提示窗口?
- 请问谁能给我VB+XML的操作例程(在线等)
- 很不错的打印msflexgrid的控件,20份一份
'##########################################
' 报表求和
'##########################################
Public Sub AddSum(msgReport As mshflex )
Dim i, j As Long
Dim sum As Double
Dim strTemp As String
With msgReport
If msgReport.Rows = 1Then Exit Sub
strTemp = "合计"
.AddItem strTemp
'判断所有的列,看是否需要计算和
For i = 1 To .Cols - 1
If InStr(1, .TextMatrix(IIf(blnAdd, 1, 0), i), "数量") > 0 Or InStr(1, .TextMatrix(IIf(blnAdd, 1, 0), i), "额") > 0 Or InStr(1, .TextMatrix(IIf(blnAdd, 1, 0), i), "款1") Or InStr(1, .TextMatrix(IIf(blnAdd, 1, 0), i), "本年") > 0 Or InStr(1, .TextMatrix(IIf(blnAdd, 1, 0), i), "本月") > 0 Or InStr(1, .TextMatrix(IIf(blnAdd, 1, 0), i), "累计") Or InStr(1, .TextMatrix(IIf(blnAdd, 1, 0), i), "次数") Then
sum = 0
For j = IIf(blnAdd, 2, 1) To .Rows - 2
If .TextMatrix(j, i) <> "" Then
If IsNumeric(.TextMatrix(j, i)) Then
sum = sum + CDbl(.TextMatrix(j, i))
End If
'
If InStr(1, .TextMatrix(IIf(blnAdd, 1, 0), i), "单价") > 0 Or InStr(1, .TextMatrix(IIf(blnAdd, 1, 0), i), "额") > 0 Or InStr(1, .TextMatrix(IIf(blnAdd, 1, 0), i), "款1") > 0 Then
.TextMatrix(j, i) = Format(.TextMatrix(j, i), "个是化成RMB的格式")
Else
.TextMatrix(j, i) = .TextMatrix(j, i)
End If
'如果为零,不显
If Trim(.TextMatrix(j, i)) = "0" Or Trim(.TextMatrix(j, i)) = "0.00" Then
.TextMatrix(j, i) = ""
End If
End If
Next j
.TextMatrix(.Rows - 1, i) = Format(sum, “格式华”)) .ColAlignment(i) = 8
End If
Next i
End With
End Sub
Dim count As Double
With MSFlexGrid1
For i = 1 To .Rows - 1
count = count + Val(.TextMatrix(i, 1)) '假设第二列是成绩
Next i
.Rows = .Rows + 1
.TextMatrix(.Rows - 1, 0) = "总计"
.TextArray(.Rows - 1, 1) = count
End With
Dim nNum As long
nnum=0
for i=2 to Grid.rows
Grid.col=2
Grid.row=inNum=nNum+Grid.text'next i
text1.text=nNum 'text1 为TEXTBOX控件
Dim nNum As long
nnum=0
for i=2 to Grid.rows
Grid.col=2
Grid.row=inNum=nNum+Grid.text
next i
text1.text=nNum 'text1 为TEXTBOX控件