Sub choix_moteur()
Application.ScreenUpdating = False
'choix moteur
If Range("A3").Value = "Moteur1a" Then
Sheets("Inventaire").Range("B2:B200").Value = Sheets("Données").Range("F2:F200").Value
For i = 2 To 200
Select Case Sheets("Données").Cells(i, 6).Font.ColorIndex
Case Is = 3
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 3
Case Else
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 6
End Select
Next i
End If
If Range("A3").Value = "Moteur1b" Then
Sheets("Inventaire").Range("B2:B200").Value = Sheets("Données").Range("G2:G200").Value
For i = 2 To 200
Select Case Sheets("Données").Cells(i, 7).Font.ColorIndex
Case Is = 3
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 3
Case Else
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 6
End Select
Next i
End If
If Range("A3").Value = "Moteur1c" Then
Sheets("Inventaire").Range("B2:B200").Value = Sheets("Données").Range("H2:H200").Value
For i = 2 To 200
Select Case Sheets("Données").Cells(i, 8).Font.ColorIndex
Case Is = 3
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 3
Case Else
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 6
End Select
Next i
End If
If Range("A3").Value = "Moteur1d" Then
Sheets("Inventaire").Range("B2:B200").Value = Sheets("Données").Range("I2:I200").Value
For i = 2 To 200
Select Case Sheets("Données").Cells(i, 9).Font.ColorIndex
Case Is = 3
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 3
Case Else
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 6
End Select
Next i
End If
If Range("A3").Value = "Moteur2a" Then
Sheets("Inventaire").Range("B2:B200").Value = Sheets("Données").Range("J2:J200").Value
For i = 2 To 200
Select Case Sheets("Données").Cells(i, 10).Font.ColorIndex
Case Is = 3
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 3
Case Else
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 6
End Select
Next i
End If
If Range("A3").Value = "Moteur2b" Then
Sheets("Inventaire").Range("B2:B200").Value = Sheets("Données").Range("K2:K200").Value
For i = 2 To 200
Select Case Sheets("Données").Cells(i, 11).Font.ColorIndex
Case Is = 3
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 3
Case Else
Sheets("Inventaire").Cells(i, 2).Interior.ColorIndex = 6
End Select
Next i
End If
'coche
Dim Cellule As Range
Dim Forme As Object
On Error Resume Next
For Each Forme In ActiveSheet.Shapes
If Forme.Type = 8 Then
Forme.Cut
End If
Next Forme
On Error GoTo 0
For Each Cellule In Range("B2:B200")
If Cellule <> "" Then
With Cellule
.Select
ActiveSheet.CheckBoxes.Add(.Left + 60, .Top, .Width, .Height).Select
End With
With Selection
.LinkedCell = Cellule.Offset(0, 1).Address
.Characters.Text = ""
End With
End If
Next Cellule
'couleur
Application.ScreenUpdating = True
End Sub