+ Reply to Thread
Results 1 to 2 of 2

Retain data in checkbox in Userform

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    1

    Retain data in checkbox in Userform

    Hi all,

    I know that this topic was already discussed, but I am still not able to find it.

    I have made a userform in excell that opens by using a button.
    In the userform i have 5 checkboxes. Depending on the status of the project none, 1 or more checkboxes will be checked. But it is important that when the userform is closed and opened again that the checkboxes that were checked stays checked

    Can you describe the process in detail and clearly mention where codes need to be written?

    Thank you very much

  2. #2
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    495

    Re: Retain data in checkbox in Userform

    If you set each checkbox to reference a cell, then use the form initialise routine to set the options for each checkbox.
    Use something like the following to close the form to save the checkbox settings.

    HTML Code: 
    In the Form Initialise routine something like:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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