+ Reply to Thread
Results 1 to 2 of 2

Retain data in checkbox in Userform

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    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
    Australia NSW
    MS-Off Ver

    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


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