VBA design patterns

[halik]

Does anyone have any references on VBA (not VB, I need the excel built in version) design patterns?
I need to write a simple little program, but I'd like to make it as maintainable as possible.


------------------------------
By now, you should know which forum to post such a thread in.

Senior Anandtech Moderator
Common Courtesy

 

[jalaram]

You may want to try this question in the Programming forum.

That said, I'm not used to seeing VBA code big enough to need a design pattern. By that point, people write an external VB program and link to Excel or whatever the host program is.