VBA inheritance, analog of super

by

The usual way to do this in VBA is to have A contain an instance of B as well as having A implement B’s interface, and then delegate calls to the B interface of A to the internal B.

This is old stuff, but see the Visual Studio 6.0 Programmer’s Guide:

http://msdn.microsoft.com/en-us/library/aa716285(VS.60).aspx

There is a chapter on “The Many (Inter)Faces of Code Reuse” that describes this convention:

http://msdn.microsoft.com/en-us/library/aa240846(v=VS.60).aspx

The way MS describes it is:

In addition to implementing abstract
interfaces, you can reuse your code by
implementing the interface of an
ordinary class, and then selectively
delegating to a hidden instance of the
class.

This means that implementation inheritance requires lots of explicit delegation methods. There’s even a chapter subheading: “Doesn’t This Get Tedious?”. Yet another reason why OOP in VBA is a PITA (TM)…

EDIT THAT WON’T FIT IN A COMMENT:

To answer the question you posed in your comment, well, an A is a B. When you make A implement B’s interface, you are essentially saying that you can treat an instance of A as if it is actually of type B. In VBA, the way you do that is by declaring a variable of type B, and then setting it to an instance of A. VBA will know what to do when you call it like a B:

Dim usedAsB as B
Dim anA as A

Set anA = New A
Set usedAsB = anA    'fine since A implements B

usedAsB.something()    'will call B_something() defined in class A

As far as what you see in the debug window, I don’t why it appears that way. And as far as forced delegation, I’m not sure what you mean. VBA automatically dispatches calls to the B interface to the right methods in the A class. If you mean automatically generating the code to inherit B’s implementation in the manner described above, there’s nothing like that I know of for VBA. I think the various “professional” versions of VB6 could do that, but I’ve never used VB6 so I don’t know.

More Related Contents:

  1. using for loop for vba
  2. Simple VBA code to open cells one after the other
  3. Open folder in new instance
  4. Copy data from cell in selected row
  5. Refer to sheet using codename
  6. VBA Macro On Timer style to run code every set number of seconds, i.e. 120 seconds
  7. Assign code to a button created dynamically
  8. Last not empty cell (column) in the given row; Excel VBA
  9. HTML Text with tags to formatted text in an Excel cell
  10. Split comma separated entries to new rows [closed]
  11. Get list of Excel files in a folder using VBA [duplicate]
  12. Select first empty cell in column F starting from row 1. (without using offset )
  13. Excel VBA – QueryTable AfterRefresh function not being called after Refresh completes
  14. Excel VBA: AutoFill Multiple Cells with Formulas
  15. VBA.Find and adding a value
  16. excel vba- extract text between 2 characters
  17. Round function in Excel, worksheet function vs VBA
  18. How to continue the code on the next line in VBA
  19. Excel VBA Userform – Execute Sub when something changes
  20. Count the number of rows in another sheet [duplicate]
  21. Getting Excel to refresh data on sheet from within VBA
  22. VBA Password Input with Cancel Function
  23. Finding first blank row, then writing to it
  24. Loop through cells and add to a range
  25. Copy last column with data on specified row to the next blank column
  26. Excel VBA- Iterate through columns in one workbook, pasting information in corresponding workbook
  27. Start VBA macro when editing a cell
  28. VBA Run-time error 438 appears when “paste” runs
  29. If Not function proceeds when value *is* the one specified
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment