VBA Code to Write VBA Code

[Tark221]

Does anyone know how I can write VBA code to Write vba code.

In the simplest explanation. I need to write code for a button which doesn't exist yet, but when the form opens it will be dynamically created, this all works, I just need to write the code for that button. We do know that the button will be called "btn1" and will display a msgbox saying hello when clicked.

Any help would be greatly appreciated

 

[pr2-eugin]

Well it looks like it could be possible. Did a simple Google search, the following came up..

http://stackoverflow.com/questions/...button-created-dynamically-using-vba-on-excel
http://www.ozgrid.com/forum/showthread.php?t=156806
http://stackoverflow.com/questions/...-dynamically-created-button-on-excel-userform

Although they are mainly shown for Excel, it is still VBA so hope it can be incorporated in Access. Good Luck !