VBA - adding List box with linked cell and ListFillRange

The Excel 2007 Recorder does not seem to register all of the parameters:
Running this code in MS Access 2007

Help: need parameters to insert a list box on my Excel Worksheet - create a linked cell, and the ListRange

' this works - but leaves out the linked cell and ListFillRange
ObjXL.ActiveSheet.OLEObjects.Add(ClassType:="Forms .ComboBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=209, Top:=36, Width:=170.25, Height:=25.5).Select

' this fails if the LinkedCell is added
ObjXL.ActiveSheet.OLEObjects.Add(ClassType:="Forms .ComboBox.1", Link:=False, LinkedCell:="D1", _
DisplayAsIcon:=False, Left:=209, Top:=36, Width:=170.25, Height:=25.5).Select

Please Login or Register  to view this content.