Adding Code to an Existing UserForm with VBA

Hello All

I hope someone can help me.

Is it possible to add some code to an existing UserFrom with VBA only?

I have around 50 spreadsheets that are being used by employees to record their work. I have now written a script to make some adjustments to these sheets and update them. The intention is that I will send out a sheet with a macro that will adjust and update their time sheet for them.

The script now does almost everything I want it to, however I would like to be able to add the following code to an existing UserForm in the workbook called "NewSheet"

Please Login or Register  to view this content.

Sorry for the long winded description but I wanted to explain why I want to make this seeming minor change through VBA.

Thanks in advance for any help you can provide.

Cheers

Jim

If the forms are all the same, I would create the form in a workbook as you want it, then export it. Then use code to remove the old one from the target workbooks and reimport the new one - see Chip's page here for example.

No, you have to alter the registry (one way or the other).
You might be better off putting the form and code into an add-in and distributing that to the users. Then you can send out updated versions of the add-in without worrying about the data being lost (since they are separate files).

I would have the form any relevant code in an addin & distribute that