I’ve been fooling around trying to get a tabledriven menu for a
userform to work.
It uses a table on a worksheet to build the menu, like in this screenshot:
Obviously I used a couple of things from Stephen Bullen, Rob Bovey and John Green’s famous book “Professional Excel Development” to build this.
I’m almost there I believe (download here).
I’d like to ask you all:
– comments (I might have a hole or two in the logic and in the
termination cleaning up of the class instances)
– A tip on how to get shortcut keys working.