Adding Code to Command Button at Run Time
 

Adding Code to Command Button at Run Time
 

http://www.cpearson.com/excel/vbe.htm is quite a cool site that tells you
all about it.

But make sure in VB Editor, you go to Tools/References and check:
- Microsoft Visual Basic for Applications Extensibility 5.3
Else some required variables won't be recognized.

If it's too hard to program the button's code in a form, I guess you put the
actual code in a module that you can modify, and let the buttonclick launch
that changing code.



"Kevin E." schreef in bericht
...