View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
I believe I believe is offline
external usenet poster
 
Posts: 1
Default 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!