/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

3 votes231 views1 answer
Extract the nth word from a text string
VBA
2 votes210 views1 answer
Vba array contains
VBA
0 vote284 views1 answer
Vba excel do not recalculate before save
VBA
1 vote233 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote256 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote239 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote235 views1 answer
Check if program is running vbnet
VBA
0 vote240 views1 answer
Vba keep command window open
VBA
1 vote211 views1 answer
Vba listindex select multiple items vba
VBA
6 votes252 views1 answer
Excel vba isalpha
VBA