Bonjour,
Un essai ...
Private Sub UserForm_Initialize()
CheckBox1.Value = IIf(Cells(9, 24).Value = "Maçonnerie", True, False)
CheckBox2.Value = IIf(Cells(10, 24).Value = "Plomberie", True, False)
CheckBox3.Value = IIf(Cells(9, 25).Value = "Electricité", True, False)
CheckBox4.Value = IIf(Cells(10, 25).Value = "Plaquiste", True, False)
CheckBox5.Value = IIf(Cells(9, 26).Value = "Peinture", True, False)
CheckBox6.Value = IIf(Cells(10, 26).Value = "Pose du sol", True, False)
CheckBox7.Value = IIf(Cells(9, 27).Value = "Finitions", True, False)
CheckBox8.Value = IIf(Cells(10, 27).Value = "Toiture", True, False)
End Sub
ric