在單元格更改時自動執行Excel宏如何在特定單元格中的值每次更改時自動執行Excel宏？現在，我的工作代碼是：Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("H5")) Is Nothing Then MacroEnd Sub哪里"H5"被監控的特定細胞Macro宏的名稱。有更好的辦法嗎？
3 回答
侃侃無極
TA貢獻2051條經驗 獲得超10個贊
Range("H5")Application.Range("H5")Application.ActiveSheet.Range("H5")
Target.Worksheet.Range("H5"):
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Target.Worksheet.Range("H5")) Is Nothing Then MacroEnd SubMe.Range("H5")
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("H5")) Is Nothing Then MacroEnd Sub
小唯快跑啊
TA貢獻1863條經驗 獲得超2個贊
Dim cell_to_test As Range, cells_changed As Range Set cells_changed = Target(1, 1) Set cell_to_test = Range( RANGE_OF_CELLS_TO_DETECT ) If Not Intersect(cells_changed, cell_to_test) Is Nothing Then Macro End If
添加回答
舉報
0/150
提交
取消