Nice one! :-)
Thanks
matt

"Tom Ogilvy" wrote in message
...
If you record a macro while you do it manually you get

ActiveSheet.OLEObjects.Add(ClassType:="Forms.Check Box.1", Link:=False,
_
DisplayAsIcon:=False, Left:=377.25, Top:=114.75, Width:=78,
Height:=
_
18.75).Select


so you could do
lTop = Range("B9").top
lLeft = Range("B9").Left
lWidth = Range("B9").Width
lHeight = Range("B9").Height
ActiveSheet.OLEObjects.Add ClassType:="Forms.CheckBox.1", _
Link:=False, DisplayAsIcon:=False, _
Left:=lLeft, Top:=lTop, Width:=lWidth, Height:=lHeight

--
Regards,
Tom Ogilvy




"Matt Jensen" wrote in message
...
Is it possible to programmatically add a form element to a worksheet
where
do you can something along the lines of specifying it's location
relative
to
a cell?
Thanks
Matt