Skip to main content

All Questions

Filter by
Sorted by
Tagged with
11 votes
2 answers
1k views

Generating and calling code on the fly

Delegate This class module defines what I'm calling, in this context, a Delegate - here a function that can take a number of parameters, evaluate a result, and ...
Mathieu Guindon's user avatar
9 votes
3 answers
1k views

Ugly workaround to get the vbext_ProcKind of a procedure is breaking encapsulation

This is a follow up to Extending the VBAExtensibility Library. It turns out that code had a really nasty bug. Anytime vbeProcedure.StartLine got called, I was ...
RubberDuck's user avatar
  • 31.1k
12 votes
1 answer
5k views

Extending the VBA Extensibility Library

The Microsoft Visual Basic for Applications Extensibility library let's us meta-program VBA, but the way it handles (or rather, doesn't handle) getting to the actual subs and functions is clunky at ...
RubberDuck's user avatar
  • 31.1k