/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 vote292 views1 answer
Worksheet.pastespecial textbox
VBA
3 votes301 views2 answers
Vba active workbook path
VBA
0 vote335 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote279 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote283 views1 answer
Windows Presentation Foundation dark title bar
VBA
9 votes398 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote302 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
0 vote301 views1 answer
Send webhook vbscript
VBA
0 vote309 views1 answer
Delete all controls in an area vb
VBA
5 votes301 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA