/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 vote208 views1 answer
Vba leading zeros in string
VBA
0 vote211 views1 answer
Get current year vb
VBA
0 vote225 views1 answer
How to format a textbox as date vb net
VBA
0 vote218 views1 answer
Refresh token em vb net
VBA
5 votes240 views1 answer
Excel vba right word from Long Integer
VBA
0 vote244 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote267 views1 answer
Vba excel parser xml
VBA
2 votes225 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote242 views1 answer
Build an index all files of a FTP site
VBA
0 vote227 views1 answer
Vbs expand env var
VBA