第一知识网
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提问