Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you Copy Objects from a Worksheet to a Userform
When I first started this spreadsheet I put a bunch of
combobox's,etc,etc on a worksheet. Now that I have learned more about good excel design practice I would like to get all of this stuff onto a UserForm. Using Excel XP I cannot copy objects from a worksheet (cntrl C) then got to the form and paste them in..........but I can drag and drop 1 object at a time onto the userform and rename it. Is there a way to copy all the objects (about 100) to the form by selecting them all then copying them over......even better is there a way they would not loose there names, but if not I would be happy to just get them all over so I do not have to redo all the positioning of them I have spent lots of time on. Any help on this one will be appreciated. Thanks in Advance Dave Baranas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy all formats and objects | Excel Discussion (Misc queries) | |||
copy objects false | Excel Discussion (Misc queries) | |||
Copy Worksheet wont copy objects. | Excel Worksheet Functions | |||
Copy a folder and objects | New Users to Excel | |||
copy userform | New Users to Excel |