Peter T : that is exactly the part that doesnt work .... I clicked the
more controls on the control toolbar and selected it. Then when
clicking onto the worksheet the error message pops: "Cannot insert
object"
what to do?

Don't know!
Just tried again no problem. Having selected it in the list need to "draw"
it onto the sheet - did you try that.

Long shot, try adding the ref in Tools References first
Microsoft Comm Control 6.0

I didn't need to do that, it got added automatically.

If stuck I can send to a workbook with the control embedded on a sheet, but
don't ask me what to do with it !

Regards,
Peter T

"CrazyPhilll" wrote in message
oups.com...
Peter T : that is exactly the part that doesnt work .... I clicked the
more controls on the control toolbar and selected it. Then when
clicking onto the worksheet the error message pops: "Cannot insert
object"
what to do?

Peter T:
yeah, the cursor changes to a little crosshair and i can draw a box
..... once i release the left or right mousbutton (wichever i draw the
box with) the error message mentioned above pops up.
Microsoft Comm Control 6.0 is already added under references in VBA.

As you can set the reference can you add it with code

Sub test()
'this in a sheet module hence "Me"
Dim oleObj As OLEObject
Dim m As MSComm

Me.OLEObjects.Add ("MSCOMMLib.MSComm.1")
Set oleObj = Me.OLEObjects(1)
Set m = oleObj.Object

Debug.Print oleObj.Name ' MSComm1
Debug.Print m.ProgId ' MSCOMMLib.MSComm.1
End Sub

Regards,
Peter T


"CrazyPhilll" wrote in message
ups.com...
Peter T:
yeah, the cursor changes to a little crosshair and i can draw a box
.... once i release the left or right mousbutton (wichever i draw the
box with) the error message mentioned above pops up.
Microsoft Comm Control 6.0 is already added under references in VBA.

thanks for the effort ........ runtime error 1004. Can not insert
Object ........
Ok, i am about to give up. To bad i can not. Could you send me a sheet
with one inserted? that would make my day !

I sent you a workbook with an MSComm embedded in Sheet1

According to this article
http://www.tek-tips.com/faqs.cfm?fid=6191

can only use the MSComm on a form (as Tom originally suggested).

It looks OK though for me on a sheet, but I've done nothing with it.

The thought occurred to me that some ActiveX controls are marked unsafe in
later Windows OS (eg Rich Text Box) and that perhaps that's why you can't
get it. But in a quick search I didn't find any reference to that effect,
but maybe double check.

Regards,
Peter T

"CrazyPhilll" wrote in message
oups.com...
thanks for the effort ........ runtime error 1004. Can not insert
Object ........
Ok, i am about to give up. To bad i can not. Could you send me a sheet
with one inserted? that would make my day !