Unfortunately, in some states (Arkansas, Hawaii, Idaho, Massachusetts, Montana, North Dakota, New Hampshire, South Carolina, and South Dakota) only a small number of reporters responded to our survey. Hence while interpreting the results from these states we should be cautious.
(March 2013) Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6, which was discontinued in 2008, and its associated integrated development environment (IDE).
I think you'd likely get better answers with a less abstract question. We know VBA can't do exactly what you're asking for in the general case, but if you'd describe a specific task where you'd like to apply the factory approach, perhaps old Access hands can give you advice on how to code it up more efficiently.