/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 vote152 views1 answer
Vba leading zeros in string
VBA
4 votes157 views2 answers
Excel vba last column with data
VBA
27 votes291 views2 answers
Vba check if file exists
VBA
0 vote145 views1 answer
Vba text to general
VBA
0 vote156 views1 answer
Excel vba prevent saving workbook
VBA
1 vote157 views1 answer
How to put a gridpain in a vbox
VBA
0 vote163 views1 answer
Remove series name from legendvbnet
VBA
0 vote156 views1 answer
Excel vba Column Name from Column Number
VBA
1 vote110 views1 answer
How to open cmd with vbd
VBA
2 votes148 views2 answers
Excel vba copy values range to another range
VBA