View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default How to generate code from VBA and... run it !

the usually cited reference:
http://www.cpearson.com/excel/vbe.htm

--
regards,
Tom Ogilvy


"Pierre Archambault" wrote:

Hi,

I want to create (via programmation) the declaration of some variables in
the declaration part of an existing module and also a new procedure in the
same module. Once done, I would like to run that procedure by clicking on a
button in an already open and running UserForm.

Thanks for your help.

Pierre