/VBA/Excel vba Run a Macro every time sheet is changed

Excel vba Run a Macro every time sheet is changed

'In the VBA code module for that particular worksheet, add this:

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    
    'The name of your Macro or subroutine goes here <--
    
    Application.EnableEvents = True
End Sub

Source: stackoverflow.com

Similar codes

0 vote224 views1 answer
Excel vba current folder
VBA
8 votes323 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote220 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote235 views1 answer
How to get value from clipboard in vbnet
VBA
1 vote178 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote228 views1 answer
Vbs send keys
VBA
0 vote237 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote228 views1 answer
Vba shape transparent
VBA
1 vote225 views1 answer
Vba delete file
VBA
0 vote228 views1 answer
Excel vba StartUpPosition
VBA