Okay, I am hoping someone here can help me. I have figured out how to double click a cell in my excel worksheet to pull up the userform used to populate the data for each record (in columns C through DA) and repopulate the userform BUT when it repopulates the form it only repopulates the textboxes not the checkboxes. The checkboxes are repopulated such that they are all greyed in with a checkmark. I can click on the checkbox and the tick appears (with the black on white check) and a second click removes the tick. What is wrong with my code? I want to repopulate the checkboxes only where a "Yes" appears in the worksheet data. HELP!!!
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 2 Then
Load RSForm
RSForm.txtTitle = Target.Offset(0, 1).Value
RSForm.txtDate = Target.Offset(0, 2).Value
RSForm.txtAuthor = Target.Offset(0, 3).Value
RSForm.txtPatentAssignee = Target.Offset(0, 4).Value
RSForm.txtPatentNumber = Target.Offset(0, 5).Value
RSForm.chkReviewArticle = Target.Offset(0, 6).Value
RSForm.chkSMMT = Target.Offset(0, 7).Value
RSForm.chkThermal = Target.Offset(0, 8).Value
RSForm.chkLaser = Target.Offset(0, 9).Value
RSForm.chkIonBeam = Target.Offset(0, 10).Value
RSForm.chkGasFlame = Target.Offset(0, 11).Value
RSForm.chkMechanical = Target.Offset(0, 12).Value
RSForm.Show
End If
End Sub