/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 vote176 views1 answer
Change "location" of binding navigator vb
VBA
0 vote163 views1 answer
Vba find sub dictionary
VBA
0 vote162 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote113 views10 answers
Vba excel create event log
VBA
0 vote171 views1 answer
Vbs expand env var
VBA
0 vote180 views1 answer
Set column width of datagridview vb.net
VBA
5 votes179 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote168 views1 answer
Excel vba Column Name to Column Number
VBA
1 vote139 views1 answer
How to open cmd with vbd
VBA
0 vote167 views1 answer
Excel vba chrw max value
VBA