Results 1 to 3 of 3

Save UserForm and reopen later semi-complete and resume

Threaded View

  1. #1
    Registered User
    Join Date
    09-28-2015
    Location
    400
    MS-Off Ver
    2010
    Posts
    4

    Save UserForm and reopen later semi-complete and resume

    Hi,

    I have quite a long form that the users have stated they want to pause halfway and resume.

    I currently have the following code to save and close:
        End With
        ActiveWorkbook.SaveAs ([txtStudentLast])
        ActiveWorkbook.Close
        End Sub
    but when I reopen it the data is written to the background sheet but the UserForm is empty ready for another entry. Can anyone help with code that would open the form where it left off? Ideally I'd want one button to "Save and Resume Later" and one button to "Save and Finish" - I suppose what I currently have is Save and Finish.

    Thank you
    Last edited by samuelle; 09-28-2015 at 04:45 AM. Reason: Code tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA checkboxes all messed up after save/reopen xlsm
    By horsefish01 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-05-2015, 07:58 AM
  2. Macro to Save current XLS, then to save as a CSV. Then close CSV and reopen XLS
    By cricker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-02-2014, 06:17 AM
  3. Code does not work when save and reopen! - Please Help
    By beginget in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2014, 03:58 AM
  4. Macro not working except in one tab, Must save and reopen to work in others.
    By donnydorko in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-17-2009, 02:25 PM
  5. save,close then reopen original
    By stevesunfold in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2008, 02:32 PM
  6. Action Pane is disabled when I save the document and reopen.
    By uma in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-10-2006, 08:59 PM
  7. Hyperlinks breaking when save/reopen file...
    By taylorj in forum Excel General
    Replies: 2
    Last Post: 04-03-2006, 04:33 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