View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default How to generate code from VBA and... run it !

Here are some references:

http://education.mondadori.it/libri/...87-2_extra.pdf

http://www.mvps.org/dmcritchie/excel/getstarted.htm

http://computerprogramming.suite101....a_for_ms_excel

"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