Asigning VBA modules on the fly...

[deserrol]

Hi,

I have a problem.

Using VB I want to insert a button into a worksheet (either a form or ActiveX button) and assign it to a specific VB module.

So, loop 5 times and each pass of the loop insert a button and then assign the executable for the button-click to, say, a module called RunMe1, RunMe2, RunMe3, etc. The modules name will actually be constant, what I cannot do is access the buttons properties to tell it which module to assign to the individual buttons.

I can loop down and insert the buttons using a template button, but after each paste it loses the reference to the module. Anyone any thoughts...

I'm using Excel 2003 and 2007.

Thanks,

Errol

[xLJer]

See the attached Excel 2003 file that creates a button
and has code ready and waiting for the new button.
This may not be the best solution, if it can be done
at all, but I gave it a try.

Please Login or Register  to view this content.

[JosephP]

if you use buttons.add it returns a button object (forms not activex-avoid activex on sheets if you can) and you can set its onaction property to the name of the macro (not module) you want it to run