Can I write something like:
*If CheckBox(i).Value = True Then
Cells(lin, i + 1).Value = "x"
Else
Cells(lin, i + 1).Value = ""
End If*
I have 20 checkboxes in a userform and dozens of code lines with IF statements to decide whether a specific cell should get an "x" or not. As column A fields in that worksheet are not available, I have to relate each checkbox number to the same number + 1 to find the correct column. I am just looking for a way to make things easier here, rsrs!
Aucun commentaire:
Enregistrer un commentaire