/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 vote317 views1 answer
Vba get application version
VBA
0 vote320 views1 answer
Vba collection key list
VBA
0 vote306 views1 answer
Vba code to select image in sheet
VBA
9 votes458 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
1 vote315 views1 answer
Add a index column power bi
VBA
0 vote287 views1 answer
How to make a if statement with vbs
VBA
0 vote335 views1 answer
Vba parameter adodb null value
VBA
0 vote284 views1 answer
Add items to combobox vb.net
VBA
3 votes316 views1 answer
Excel vba change format of cell
VBA
0 vote314 views1 answer
Vbnet get file name from path
VBA