第一知识网
www.001rz.comEXCEL中A1单元每输入一个数在B2中就累加
日期:2009-05-09 07:05:46 人气:27
按 Alt+F11 键,双击左边 ThisWorkbook,在右边窗格中粘贴下列代码
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = "$A$1" Then
Cells(2, 2).Value = Cells(2, 2).Value + Cells(1, 1).Value
End If
End Sub
关闭代码窗口,回到EXECL,
上一篇:excel同一个单元格内两个数字先求积在相加,怎么算?如图,C1为A1*B2,C2数值=2*3+1*3,C3同上
下一篇:there are some water in the bottle.对some提问
下一篇:there are some water in the bottle.对some提问