+ Reply to Thread
Results 1 to 1 of 1

VBA form that saves a new sheet inside the document each time it's saved

  1. #1
    Registered User
    Join Date
    09-28-2015
    Location
    Sweden
    MS-Off Ver
    Office 2013
    Posts
    1

    VBA form that saves a new sheet inside the document each time it's saved

    Hi.

    Excel-beginner here. I'd like to know if it's possible to create a VBA form (stand-alone or inside an excel-document doesn't matter for me)
    that saves all the input data into it's own sheet. The sheet should be saved with the same name provided in the textfield "Name" in the form.

    I hope you understand my explanations. After each click on the "Save" button in the form, the form should go blank again and next time you
    use it the form creates a new sheet, filling the Excel-document with new ones every time.

    Is this possible? Can you please point me to any good tutorials. I've googled and found some tutorials about creating a VBA form but none
    that present the possibility to add a function that creates a new sheet inside the same document.

    I haven't got much experience in VB programming but have seen some code and it doesn't look that hard to understand.

    EDIT:
    The purpose of this is to be able to customize the form-fields and making it easier/faster
    to enter information about certain projects. Also to be able to return and add more info/pictures/
    calculations later on, in each "project" (sheet).

    That's why I want every project to be saved in the same Excel-book. But if anyone have other ideas
    how to pursue this (outside of Excel) I'd be glad to hear them
    Very nice forum btw! :-)


    Thanks in advance for your expertise!
    Last edited by backwrdsman; 09-29-2015 at 03:35 AM.
    The ratio of people to cake is too big.

+ 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: 0
    Last Post: 12-16-2014, 10:12 AM
  2. Run-time error 1004 Document not saved....
    By ey_up in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2014, 04:47 AM
  3. Run-time error '1004': Document Not Saved (while using LockXLS)
    By lottidotti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2013, 12:14 PM
  4. Creating a Word Document with a submission form that is saved as a PDF
    By avidcat in forum Word Formatting & General
    Replies: 1
    Last Post: 10-13-2012, 07:19 AM
  5. Excel 2007 : Run Time Error 1004 - Document not saved
    By Villamankh in forum Excel General
    Replies: 2
    Last Post: 12-17-2010, 09:44 AM
  6. [SOLVED] Run-time error '1004'; Document not saved - intermittent
    By Kerry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-15-2005, 07:15 PM
  7. Copying cells from one sheet to another if document has been saved.
    By a94andwi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2005, 07:08 AM

Tags for this Thread

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