I started doing something similar to this a while back (completely owner-drawn), it is nowhere near complete but if you would like the code just email me and I'll send it over.
I try MsFlex grid editable using MsFlex and text box
Your Question is to that using ActiveX control,
I have no idea about doing such one using ActiveX.
But it is possible. See my attachment and try using ActiveX