Creating UserControl with VB6 for excel

[Mika]

Hi,

Could somebody point me to a tutorial or a code for creating
usercontrols .ocx (VB6) to be used in VBA forms?

Thanks
Mika

 

[GS]

It happens that Mika formulated :

Hi,

Could somebody point me to a tutorial or a code for creating
usercontrols .ocx (VB6) to be used in VBA forms?

Thanks
Mika

Hi Mika,
Any OCX you create with VB6 will be 32bit and so can only be used in
32bit Excel. Also, this would be no different than creating an OCX for
VB6 use. You might get a better response asking in a VB6 (Classic VB)
forum.

Note also that any existing VB6 OCXs can usually be used on MSO
Userforms without any problems. These would have to be distributed,
however, and properly registered on the target machine.

Another thing to keep in mind is VBA doesn't support control arrays!<g>

 

[Peter T]

Here's one tutorial

http://cuinl.tripod.com/tutorials.htm
http://cuinl.tripod.com/tutorials/ocx-11.htm

Regards,
Peter T