View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jase[_2_] jase[_2_] is offline
external usenet poster
 
Posts: 29
Default Copying a userform into a new workbook

I have a workbook, named workbook("base"), with a specific worksheet in
it, and I perform the following method:

worksheet(1).copy

I then want to be able to copy the userform "UsrFrm1" from
workbook("base") into the new workbook that is created when i do
"worksheet(1).copy"

do i need to use objects in the VBE model, or is it easier than that?

thanks in advance

Jason.