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
Bookmarks