excel VBA run macro automatically whenever a cell is changed

by

Yes, this is possible by using worksheet events:

In the Visual Basic Editor open the worksheet you’re interested in (i.e. “BigBoard”) by double clicking on the name of the worksheet in the tree at the top left. Place the following code in the module:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Me.Range("D2")) Is Nothing Then Exit Sub
        Application.EnableEvents = False 'to prevent endless loop
        On Error Goto Finalize 'to re-enable the events      
        MsgBox "You changed THE CELL!"
    End If
Finalize:        
    Application.EnableEvents = True
End Sub

More Related Contents:

  1. SumIf using Excel VBA
  2. How can I call a macro which contains a loop but only run one iteration of that loop?
  3. VBA comma separated cells, needt last entry only
  4. How can I find last row that contains data in a specific column?
  5. Copy from one workbook and paste into another
  6. Open Excel file for reading with VBA without display
  7. Wait for shell command to complete [duplicate]
  8. Excel VBA App stops spontaneously with message “Code execution has been halted”
  9. How to return the number of dimensions of a (Variant) variable passed to it in VBA [duplicate]
  10. How to add a named sheet at the end of all Excel sheets?
  11. How to remove all non alphanumeric characters from a string except period and space in excel?
  12. Find last used cell in Excel VBA
  13. VBA general way for pulling data out of SAP [closed]
  14. Does Dir() make any guarantee on the order of files returned?
  15. Call a Sub with a String
  16. How to clear memory to prevent “out of memory error” in excel vba?
  17. Assign on-click VBA function to a dynamically created button on Excel Userform
  18. Assign keyboard shortcut to run procedure
  19. return csv file as recordset
  20. Excel macro -Split comma separated entries to new rows [duplicate]
  21. Get text from clipboard using GetText – avoid error on empty clipboard
  22. Benchmarking VBA Code
  23. The MacScript function is not working well in Office for Mac 2016! Any ideas?
  24. Display milliseconds in Excel
  25. VBA editor auto-deletes spaces at the ends of lines
  26. Select entire column in table using Excel VBA
  27. Application.Quit command not closing the entire Excel Application
  28. Trying to open the workbook in separate instance
  29. Function Overloading and UDF in Excel VBA
  30. VBA Excel simple Error Handling

Leave a Comment