Creating UserControl with VB6 for excel

  • Thread starter Thread starter Mika
  • Start date Start date
M

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
 
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
Click to expand...

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>
 
Back
Top