dimanche 21 décembre 2014

"Checkbox(i)", is it possible?

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