/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 vote291 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote307 views1 answer
Set datetimepicker value to null vb
VBA
1 vote282 views1 answer
Add rows to datagridview vb.net
VBA
0 vote297 views1 answer
Vba open report
VBA
0 vote301 views1 answer
How to mount floppy disks in vb.net
VBA
-1 vote295 views1 answer
VBA check if a cell contains a letter or string
VBA
8 votes410 views1 answer
Excel vba make word from bytes
VBA
5 votes274 views1 answer
Excel vba high word from Long Integer
VBA
0 vote271 views1 answer
Excel vba extract year
VBA
1 vote300 views1 answer
Vba format string as cash
VBA