New here, but hope you can help. Building an app with 44 checkbox alternatives. They can be be all or some activated. Each chekbox is linked to a statement that will be printed on a form. My problem is how do I create shortcut code to address the true/false nature of each checkboxs and have it go into the next appropriate field in the form?
Private Sub Checkbox1_()
If CheckBox1 = True Then
Worksheets("D1").Range("a10,F10") = (1)
Worksheets("d1").Range("c10") = ("AD96-18-05")
Worksheets("D1").Range("c11") = ("DUE")
Else
If CheckBox2 = True Then
Worksheets("D1").Range("C10") = ("CEB-A-73-3032 ")
Worksheets("D1").Range("C11") = ("DUE")
End If
End sub
This would be fine for even 10 events, but 44? There has to be a streamlline effect for this. Please help.
Private Sub Checkbox1_()
If CheckBox1 = True Then
Worksheets("D1").Range("a10,F10") = (1)
Worksheets("d1").Range("c10") = ("AD96-18-05")
Worksheets("D1").Range("c11") = ("DUE")
Else
If CheckBox2 = True Then
Worksheets("D1").Range("C10") = ("CEB-A-73-3032 ")
Worksheets("D1").Range("C11") = ("DUE")
End If
End sub
This would be fine for even 10 events, but 44? There has to be a streamlline effect for this. Please help.