+ Reply to Thread
Results 1 to 2 of 2

COMBINE SEVERAL USERFORMS IN A MULTIPAGE ONE - excel 2010

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-07-2015
    Location
    cyprus
    MS-Off Ver
    Microsoft 365
    Posts
    183

    COMBINE SEVERAL USERFORMS IN A MULTIPAGE ONE - excel 2010

    Good morning

    In an excel file I have 3 separate userforms that I would like to combine in a multipage userforms.

    Is there an easy way to do it keeping the format/appearance of each or am I obliged to copy / paste and to rearrange all manually?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,921

    Re: COMBINE SEVERAL USERFORMS IN A MULTIPAGE ONE - excel 2010

    You have to copy and paste but you can select all the controls of a form at once to copy, then when you paste their relative positions will be preserved.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2010 – VBA Userforms – Getting errors when item from combo box is not selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2015, 09:36 AM
  2. [SOLVED] Excel 2010 – VBA Userforms – How to connect 2 buttons to refer/use the same code?
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2015, 11:26 PM
  3. Multipage problem with userforms
    By zhenry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2014, 11:00 AM
  4. [SOLVED] Printing multi layer multipage userforms
    By MeerkatMatt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2014, 11:22 AM
  5. Userforms and cell updates in Excel 2010
    By djelliston in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-03-2014, 11:35 AM
  6. [SOLVED] multipage userforms
    By mickisme in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-27-2012, 04:01 AM
  7. [SOLVED] Add tabs to multipage in userforms
    By shnim1 in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 03:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1