1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| If ActiveSheet.CheckBox1.Value = True Then
liste.Add Array("EAP1", Workbooks("blablabla.xlsx").Worksheets("blabla").Cells(8, 3).Value)
End If
If ActiveSheet.CheckBox2.Value = True Then
liste_EAP.Add Array("EAP2", Workbooks("blablabla.xlsx").Worksheets("blabla").Cells(8, 5).Value)
End If
If ActiveSheet.CheckBox3.Value = True Then
liste_EAP.Add Array("EAP3", Workbooks("blablabla.xlsx").Worksheets("blabla").Cells(8, 7).Value)
End If
If ActiveSheet.CheckBox4.Value = True Then
liste_EAP.Add Array("EAP4", Workbooks("blablabla.xlsx").Worksheets("blabla").Cells(8, 9).Value)
End If
If ActiveSheet.CheckBox5.Value = True Then
liste_EAP.Add Array("EAP5", Workbooks("blablabla.xlsx").Worksheets("blabla").Cells(8, 11).Value)
End If
If ActiveSheet.CheckBox6.Value = True Then
liste_EAP.Add Array("EAP6", Workbooks("blablabla.xlsx").Worksheets("blabla").Cells(8, 13).Value)
End If
If ActiveSheet.CheckBox7.Value = True Then
liste_EAP.Add Array("EAP7", Workbooks("blablabla.xlsx").Worksheets("blabla").Cells(8, 15).Value)
End If |
Partager