[已解决]如何检测多个单元格数值变化

710681665

怎么样让表格检测多个单元格,某个单元格数值发生变化则执行对应的宏.我试了好久一直都不行,求大神帮帮忙!!谢谢了!

最佳答案

月排行榜 / 总排行榜

chart888

2017-6-3 08:36

1. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
   
2. 
   
3. If Target.Address = "$B$4" Then
   
4.     Call 宏1
   
5. End If
   
6. If Target.Address = "$B$7" Then
   
7.     Call 宏2
   
8. End If
   
9. If Target.Address = "$B$11" Then
   
10.     Call 宏3
    
11. End If
    
12. 
    
13. End Sub
    

复制代码

跳转到最佳答案楼层

砂海

单元格Change事件程序

chart888

1. Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
   
2. 
   
3. If Target.Address = "$B$4" Then
   
4.     Call 宏1
   
5. End If
   
6. If Target.Address = "$B$7" Then
   
7.     Call 宏2
   
8. End If
   
9. If Target.Address = "$B$11" Then
   
10.     Call 宏3
    
11. End If
    
12. 
    
13. End Sub
    

复制代码