Sub Affichage_X_Listes()
Dim x As Integer
Dim lien As Integer
Dim a As Integer
Dim b As Integer
Dim c As String
x = ActiveSheet.Cells(2, 3).Value
lien = 1
a = 100
b = 1
c = ("J" & b & ":J" & b)
For i = 1 To x
ActiveSheet.DropDowns.Add(200, a, 150, 20).Select
Application.CutCopyMode = False
Application.CutCopyMode = False
With Selection
.ListFillRange = "$K$1:$K$10"
.LinkedCell = c
.DropDownLines = 5
.Display3DShading = False
End With
a = a + 40
b = b + 1
Next
End Sub