Sub macro1()
Dim myobj As OLEObject, target As Range
For i = 1 To 10
For j = 1 To 10
Sheet2.Cells(i, j).Select
Set target = ActiveCell
Set myobj = Sheet2.OLEObjects.Add(ClassType:="Forms.combobox.1", Link:=False, DisplayAsIcon:=False, Left:=target.Left, Top:=target.Top, Width:=target.Width, Height:=target.Height)
myobj.Visible = True
Next
Next
End Sub