copying controls in UserForm
Posted by Artem on April 11, 2001 9:40 AM
i am doing a multi-page (a bunch of tabs form) on my userform. evry tab of this multi-page will have similar controls similarly laid out. i created one page (tab) and i was just wondering if there's a way to copy this page several times in multipage, just like worksheet can be copied within a workbook (it's kind of painful to layout every page just like the previous one). thanks!
Posted by Dave Hawley on April 11, 2001 9:46 AM
Hi Artem
Sounds like you would be better off with a TabStrip. These are designed so that the controls on one page are available on all pages.
But if you do want a Multipage, you can push Ctrl+A (to select all controls) Copy them to the new page, then copy the code and use the Edit>Replace to change their names.
Dave
OzGrid Business Applications
Posted by cpod on April 11, 2001 9:47 AM
Just drag your mouse around the controls to select them all and Control+C, go to the next tab and Control+V.
