How to implement custom iterable class in VBA

by

The long and short of it is you can’t implement IUnknown. The same goes for Collection. They’re both Com objects that are unavailable for extension in VBA. You can create custom collections and do other very cool iterable things though.

More Related Contents:

  1. What are the benefits of using Classes in VBA? [closed]
  2. Reducing WithEvent declarations and subs with VBA and ActiveX
  3. Print function selecting wrong Type of Change option excel vba
  4. What is the difference between .text, .value, and .value2?
  5. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  6. Check if the file exists using VBA
  7. How can I create a progress bar in Excel VBA?
  8. Compare double in VBA precision problem
  9. Row count on the Filtered data
  10. Excel VBA Macro: User Defined Type Not Defined
  11. Automate IE via Excel to fill in a dropdown and continue
  12. Run-Time error 1004 Excel 2013
  13. VBA rounding problem
  14. Pasting an Excel range into an email as a picture
  15. Excel VBA to Export Selected Sheets to PDF
  16. Controlling Internet Explorer local intranet using Excel VBA
  17. 2 ways for “ClearContents” on VBA Excel, but 1 work fine. Why? [duplicate]
  18. Excel 2013 VBA Clear All Filters macro
  19. Rounding in MS Access
  20. Count unique values in Excel
  21. Get length of array?
  22. Bad data selection using VBScript , on date field values
  23. Sum function in VBA
  24. Find last row in range
  25. Differences between Excel’s Form Controls & ActiveX Controls
  26. How to save Excel Workbook to Desktop regardless of user?
  27. How to add an attachment to an email using VBA in Excel
  28. How to change Format of a Cell to Text using VBA
  29. Excel VBA Run-time error ’13’ Type mismatch
  30. ThisWorkbook.FullName returns a URL after syncing with OneDrive. I want the file path on disk

Leave a Comment