+ Reply to Thread
Results 1 to 4 of 4

UserForms and saving

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    UserForms and saving

    Dear members,
    I have a userform used to populate the cells of a template worksheet. This has left me with two problems I cant solve.
    First I would like to be able to hide the form and check the filled template. If I do this though I cant get the form back which I need to do to use a button to file the completed template. I f I work round this by say having a button on the sheet to unhide the form then of course when it appears it is empty. Is there a way round this?

    My second problem concerns the filing. I wish only to save the newly filled template as a new file name. I have only succeeded in filing the filled template together with the userform and all associated code. Idealy I would like to file the completed sheet as a workbook with only this one sheet. Is this possible? and if so how can I do it.
    John

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: UserForms and saving

    Don't use Unload for the UserForm use, that will clear the entries. This code will not

    Please Login or Register  to view this content.
    To save the sheet only

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: UserForms and saving

    Dear RoyUK
    Sorry about the delay in responding to your help, I have been away.
    The code you suggested solved the filiing problem thanks.
    The problem with the userform is more intractable.
    I am using the form to populate records in a worksheet. Several of the fields are calculated and my users feel a need to check some fields as they go. With the form in position the work sheet is can be partly seen but not scrolled or moved in any way. The problem I have is If I hide the form so I can activate the sheet how do I then get the form to show?

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: UserForms and saving

    You need to set the UserForm's ShowModal property to False

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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