Help with using an activex control
 

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?

Help with using an activex control
 

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?

Help with using an activex control
 

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.

Help with using an activex control
 

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.

Help with using an activex control
 

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 !

Help with using an activex control
 

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 !

Help with using an activex control
 

That ActiveX control needs to be properly Licenced, so if you have
Classic VB6 then it would be licenced and you would have a registration
entry under;

HKEY_CLASSES_ROOT\Licenses\4250E830-6AC2-11cf-8ADB-00AA00C00905

and

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Licenses\4250E 830-6AC2-11cf-8ADB-00AA00C00905

You will find similar contols in VBA that are in VB6 that require this.


--
Ivan F Moala


------------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...fo&userid=1954
View this thread: http://www.excelforum.com/showthread...hreadid=534898

Help with using an activex control
 

Hi Ivan,

Indeed I have vb6 and that License. Not sure about the OP (Phil), but he had
earlier said he was able to set a reference to the control, just couldn't
add the actual control.

I sent Phil a wb with the control embedded on a sheet but otherwise empty.
He returned it to me with a small working demo.

Regards,
Peter T

"Ivan F Moala"
wrote in message
...

That ActiveX control needs to be properly Licenced, so if you have
Classic VB6 then it would be licenced and you would have a registration
entry under;

HKEY_CLASSES_ROOT\Licenses\4250E830-6AC2-11cf-8ADB-00AA00C00905

and


HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Licenses\4250E 830-6AC2-11cf-8ADB-00AA00C
00905

You will find similar contols in VBA that are in VB6 that require this.


--
Ivan F Moala


------------------------------------------------------------------------
Ivan F Moala's Profile:
http://www.excelforum.com/member.php...fo&userid=1954
View this thread: http://www.excelforum.com/showthread...hreadid=534898