How do I define a macro that will generate VBA code?
Hi,
What I basically want to do is to press a button and have a new worksheet
created and for that worksheet to have a ready-made set of subroutines
pre-defined by me.
Coming from a Java background, I'm used to defining a Class in which there
are various subroutines and then calling a constructor method to create an
instance of that class containing all the little subroutines etc.
I haven't had much luck in finding any microsoft tutorials - can anyone help
me out?
Many thanks in advance!
|