View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's)

Tom's answer assumes you want a picture of the userform. I read your
question to mean you wanted a second copy of the form.

One way: Export the form, change the name of the existing form, and import
the original.

Another way: Drag the form into another VB Project (just create a new
temporary workbook for this), change the name of either form, and drag the
form beck into the original project.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Corey" wrote in message
...