Create Event Code

[robg37]

I have a form with a command button that has VBA code run when you click it. When you click this button, it creates a new form and adds controls to the form. Now I need a way to specify VBA code that runs when various control's events occur on the new form. Any ideas on how to write VBA code that creates VBA code in another module?

Thanks!

Rob G.

 

[MichaelRed]

There was a thread on the topic recently. Use the search capability to find it.
MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[baronvont]

See the topic "Edit functions 'on the fly'" yesterday, but it probably won't help a lot

 

[robg37]

I found the answer! Look at the Microsoft Knowledge Base article Q187318. It talks about how to programmatically create and modify code.

Happy coding!