/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

32 votes322 views2 answers
Excel vba column letter
VBA
0 vote231 views1 answer
Vba verticalalignment
VBA
0 vote292 views2 answers
Excel vba store array and write to sheet
VBA
1 vote229 views1 answer
Excel vba compare 2 rows
VBA
1 vote201 views1 answer
How to open cmd with vbd
VBA
2 votes225 views1 answer
Excel vba date to string conversion
VBA
0 vote216 views1 answer
Create new worksheet excel visual basic
VBA
1 vote245 views1 answer
Set font for ms chart vb.net
VBA
0 vote224 views2 answers
Excel vba close without saving
VBA
0 vote253 views1 answer
Reference to a non-shared member requires an object reference
VBA