Dim cnt as integer
For Each r As Row In Tables("表A").Rows If r("是否过账") = false Then r("是否过账") = True
cnt = cnt +1 End IfNext
if cnt = 0 then
MessageBox.Show("没有要处理的数据哟,已全部过账啦!", "提示", MessageBoxButtons.ok)else
MessageBox.Show("过账完毕,合计过账" & cnt & "条记录", "提示", MessageBoxButtons.ok)end if