+ Reply to Thread
Results 1 to 2 of 2

Saving CheckBox choices????

  1. #1
    Registered User
    Join Date
    07-16-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    12

    Question Saving CheckBox choices????

    As you can see by the code below I am assigning either "True" or "False" depending on the state of the checkbox to a range of cells in my workbook. What I need to do is have whatever has been check in the userform to get saved allowing the userform to show the same selection before it was closed. I was wondering if there was a way to reverse this by looking at the range of cells in the workbook and setting the checkbox to that value before the userform was to open. If the cell read "True", then the checkbox would have a checkmark in it, "False" would remain blank.



    Please Login or Register  to view this content.
    Last edited by eptownie1988; 12-09-2014 at 02:54 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Saving CheckBox choices????

    Hello eptownie1988,

    Add this macro code above the first line in your UserForm.
    Please Login or Register  to view this content.
    Add this macro code below the last line in the UserForm code.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Corrupt Checkbox After Saving
    By mattman123 in forum Excel General
    Replies: 3
    Last Post: 07-30-2013, 03:38 PM
  2. Saving and changing values based on a checkbox
    By kaligad in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-19-2012, 08:04 AM
  3. Drop-down list choices restricting choices of other lists?
    By not_quite_excelling in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2011, 06:04 AM
  4. Checkbox choices that run code on clicking command button
    By Sharky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2007, 05:30 PM
  5. Do not save a checkbox value when saving or close
    By TimE in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-15-2006, 03:25 PM

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