Skip to content

This is an example of how to uses Interfaces in VBA. This example uses the Observer Design Pattern as a demonstration.

License

Notifications You must be signed in to change notification settings

zq99/interface-implementation-in-vba

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Interface Example using VBA

Purpose

This was an experiment to try and model the Observer design pattern architecture in VBA using Interfaces.

It's not the full implementation of the pattern as found in other languages, the idea was merely for the code to be a reference point to show how to use an Interface.

Setup

  1. Create a new workbook.
  2. Import all of the classes, modules and interfaces in this repo into the workbook. If you choose to paste the code into classes you create, then you should remove any text in red that appears at the top of each file (this is boiler plate code generated when files are exported from the VBE).
  3. Run the test macro called 'TestObserverPattern'. You should see the results outputted to the Immediate Window.

About

This is an example of how to uses Interfaces in VBA. This example uses the Observer Design Pattern as a demonstration.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages