/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

2 votes191 views1 answer
Excel vba check if key is in collection
VBA
0 vote200 views1 answer
Excel filter by date not working vba
VBA
0 vote207 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote195 views1 answer
Limit combobox to list vba
VBA
1 vote193 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote208 views1 answer
Vba clear collection
VBA
8 votes252 views1 answer
Excel vba make word
VBA
3 votes195 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote209 views1 answer
Vba static variable
VBA
2 votes201 views1 answer
Vba split string
VBA