1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
If ThisWorkbook.Worksheets("CalculTarif").Cells(3, 2) = "Salarié" Then
For i = 8 To 14
If ThisWorkbook.Worksheets("Tarifs étendus").Cells(i, 1).Value = ThisWorkbook.Worksheets("ENTREES").Cells(8, 9).Value And ThisWorkbook.Worksheets("ENTREES").Cells(8, 9).Value > 20 Then
If ThisWorkbook.Worksheets("CalculTarif").Cells(6, 3).Value = "IDF" Then
UserForm3.Lbl_Prix_An_Enf1.Caption = ThisWorkbook.Worksheets("Tarifs étendus").Cells(i, j).Value * Pourcentage
Else
UserForm3.Lbl_Prix_An_Enf1.Caption = ThisWorkbook.Worksheets("Tarifs étendus").Cells(i, j).Value
End If
Tarif_Enfant1 = UserForm3.Lbl_Prix_An_Enf1.Caption
Tarif_Enfant1 = Format(Tarif_Enfant1, "#.00")
UserForm3.Lbl_Prix_An_Enf1.Caption = Tarif_Enfant1
End If
Next i
End If |