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" wrote in message
...
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 ***