Results 1 to 5 of 5

saving selections in userform

This is a discussion on saving selections in userform within the Excel Questions forums, part of the Question Forums category; I have a userform that recieves input from the user via textboxes and checkboxes. How can retain the input information ...

  1. #1
    Board Regular
    Join Date
    Apr 2003
    Posts
    111

    Default saving selections in userform

    I have a userform that recieves input from the user via textboxes and checkboxes. How can retain the input information in the userform.
    NL

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    64,611

    Default Re: saving selections in userform

    You will need to save it somewhere when you unload the UserForm, eg a hidden worksheet or a text file, and reload it when the form is initialised.

  3. #3
    Board Regular
    Join Date
    Apr 2003
    Posts
    111

    Default Re: saving selections in userform

    Is this the only way? Can I somehow use varaibles in the VBA to retain the values?

    NL

  4. #4
    MrExcel MVP Richie(UK)'s Avatar
    Join Date
    May 2002
    Location
    UK
    Posts
    3,330

    Default Re: saving selections in userform

    Hi Nick,

    You could make use of some Public variables, but this is generally not advisable. Can you give us a little more information regarding what exactly you are trying to achieve?
    Richie

  5. #5
    Board Regular
    Join Date
    Apr 2003
    Posts
    111

    Default Re: saving selections in userform

    I have created a userform that has several checkboxes. Based on what checkboxes are selected, excel will create a new sheet for each checkbox that is selected. My problem lies in a scenario where the user wants to change the previously made selections. I only want the user to have to deselect his previous selections or select additional selections. This is just to help prevent user error. I have already created a macro that prevents excel from creating duplicate new sheets.

    Hopefully I was able to explain this clearly enough.

    NL

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com