/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 vote147 views1 answer
Vlookup columns not next to each other
VBA
0 vote156 views1 answer
Vba get application version
VBA
1 vote143 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
3 votes149 views1 answer
Extract the nth word from a text string
VBA
0 vote148 views2 answers
Excel vba close without saving
VBA
3 votes166 views1 answer
Vba double quote
VBA
2 votes150 views1 answer
Excel vba check if key is in collection
VBA
0 vote174 views1 answer
Excel vba round to whole number
VBA
2 votes175 views2 answers
Excel vba if sunday or staurday
VBA
0 vote147 views3 answers
Write to text file vb.net
VBA