Results 1 to 2 of 2

Saving CheckBox choices????

Threaded View

  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.



    Private Sub CheckBox100_Click()
    
        Range("J1778:J1783").Value = CheckBox100.Value
    
    End Sub
    
    Private Sub CheckBox101_Click()
    
        Range("J1784:J1789").Value = CheckBox101.Value
    
    End Sub
    
    Private Sub CheckBox102_Click()
    
        Range("J1674:J1680").Value = CheckBox102.Value
    
    End Sub
    Last edited by eptownie1988; 12-09-2014 at 02:54 PM.

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