+ Reply to Thread
Results 1 to 5 of 5

Multiple Form Instance in Same Worrkbook

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2013
    Posts
    35

    Multiple Form Instance in Same Worrkbook

    I currently have a single worksheet based entry form that uses named cell ranges in vba scripts that outputs the structured form data into another workbook where all data for a single form is on a single row.

    I want to be able to have multiple worsheets of the same form. So idea is to ask user how many Forms they want, then create that number of the forms (all identicle) for completion.... and then run a script that outputs each form to a separate row in the other workbook

    But how do you do that if every Form has the same named cell ranges? Is there a way reference unique sheet# & range?

    Hope someone understands what trying to achieve.

    Thanks,
    Mark

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Multiple Form Instance in Same Worrkbook

    Hello britinva,

    Named Ranges have two levels of scope (visibility): Workbook and Worksheet. The named range would have to be created for each worksheet and its scope set to worksheet level.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    09-18-2012
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Multiple Form Instance in Same Worrkbook

    Thanks for reply Leith.

    So if understand right - I cannot create a say a master sheet with the named ranges then if user say's I want 15 forms I cannot create 15 copies of the master.

    Only way would be to say have a number of forms created, each with the ranges specified at worksheet level ..... and then unhide how many sheets the user wants?

    Is that accurate?

    Cheers,
    Mark

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Multiple Form Instance in Same Worrkbook

    Mark

    No, when you create the named ranges on the master worksheet make sure they are worksheet level rather than workbook level.

    When you copy the master worksheet the named ranges on the copied sheet will refer to the copied sheet and not the master sheet.
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    09-18-2012
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Multiple Form Instance in Same Worrkbook

    Thanks - will try that out

+ 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. Replies: 2
    Last Post: 09-16-2011, 07:45 AM
  2. Finding only 1 instance not multiple
    By SarahPintal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-27-2010, 01:36 AM
  3. One instance using multiple workbooks
    By pasjr1972 in forum Excel General
    Replies: 1
    Last Post: 07-26-2009, 07:01 PM
  4. Time-Tracker form, multiple instance of Excel
    By Duncan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2006, 10:40 AM
  5. opening form in new instance of excel
    By riva91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2006, 10:10 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