UserForm Question:must be activated via a button

Good morning,

I am getting a large spreadsheet from Germany that has a user form in it
already but not to our South African requirements. Is it possible to
make a userform, lets say in my Parsonal workbook and copy it into this
workbook with it's relevant code, so that it then has two user forms in
? The userform must be activated via a button on the spreadsheet.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

Yes. In the VB IDE you can just drag/copy the userform module from
Personal.xls to the new workbook. If you remove the userform module from the
new workbook before, you can preserve the same name.

--
HTH

Bob Phillips

"Tempy" <anonymous@devdex.com> wrote in message
news:OjpuRoDXFHA.580@TK2MSFTNGP15.phx.gbl...
> Good morning,
>
> I am getting a large spreadsheet from Germany that has a user form in it
> already but not to our South African requirements. Is it possible to
> make a userform, lets say in my Parsonal workbook and copy it into this
> workbook with it's relevant code, so that it then has two user forms in
> ? The userform must be activated via a button on the spreadsheet.
>
> Tempy
>
> *** Sent via Developersdex http://www.developersdex.com ***

Thanks Bob.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***