Copy / Paste Userform

Posted by Paul Magruder on June 08, 2001 11:26 AM

Is there code that will allow me to copy a userform ( userform2)to the clipboard, and then paste it to the active sheet? Can't seem to get it there...
Userform2.copy
sheets("sheet1").select
range("a1").select
activesheet.paste

Won't do it....

Thanks
Paul

Posted by Joe Was on June 08, 2001 3:02 PM

Sub R_Insert()
'
' R_Insert Macro
' Macro by JSW
'
' Keyboard Shortcut: Ctrl+r
'
Sheets("Sheet1").Select
Userform2.Select
Selection.Copy
Worksheets(Array("Sheet1")).Select
ActiveSheet.Paste
End Sub

Change or remove the Worksheet Array if your form is not allowed! JSW