How can an Excel Add-In respond to events in any worksheet?

by

Don’t use the New keyword in the dim statement. You’re telling it to instantiate the class when it’s needed, but then you never refer to it again, so it’s never needed. Instead:

Public MySheetHandler As SheetChangeHandler

Sub Auto_Open
   Set MySheetHandler = New SheetChangeHandler
End Sub

That line in the Auto_Open (which runs at startup) will instantiate the class.

More Related Contents:

  1. How do I get values from a hidden worksheet using VBA [closed]
  2. How to copy cells that contain certain text to another worksheet [closed]
  3. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  4. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  5. How do I base64 encode a string efficiently using Excel VBA?
  6. Programmatic Access To Visual Basic Project Is Not Trusted
  7. Can I make this macro more efficient or faster?
  8. Conditional Formatting using Excel VBA code
  9. Controlling IE11 “Do you want to Open/Save” dialogue window buttons in VBA
  10. How to get the background color from a Conditional Formatting in Excel using VBA
  11. VBA Excel Populate ListBox with multiple columns
  12. VBA Integer Overflow at 70,000
  13. How to count up text of a different font colour in excel
  14. How to “flatten” or “collapse” a 2D Excel table into 1D?
  15. VBA Macro to compare all cells of two Excel files
  16. VBA – How the colon `:` works in VBA code with condition
  17. How to create a separate CSV file from VBA?
  18. VBA – Update Other Cells via User-Defined Function
  19. VBA: How to change the value of another cell via a function?
  20. Running VBA from a HYPERLINK()
  21. Sending formatted Lotus Notes rich text email from Excel VBA
  22. How can I generate GUIDs in Excel?
  23. Range.Find not making a difference between January and November (February and December) in VBA Excel
  24. Remove Duplicates from range of cells in excel vba
  25. Excel Select vs Activate
  26. How to filter listbox values based on a Textbox value
  27. Find and FindNext for Excel VBA
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment