Sub ttt()
With Worksheets("commande en cours")
Dim t, l, i
i = 1
Do While .Cells(i, 1).Value <> ""
t = .Cells(i, 8).Top
l = .Cells(i, 8).Left
.OLEObjects.Add ClassType:="Forms.CheckBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=l + 15, Top:=t + 4, Width:=10, Height:=10
i = i + 1
Loop
End With
End Sub