Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Could somebody point me to a tutorial or a code for creating usercontrols .ocx (VB6) to be used in VBA forms? Thanks Mika |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's one tutorial
http://cuinl.tripod.com/tutorials.htm http://cuinl.tripod.com/tutorials/ocx-11.htm Regards, Peter T |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UserControl | Excel Programming | |||
Creating VBA Functions When Creating Spreadsheet Via VBA? | Excel Programming | |||
after creating macro button, closed excel then restarted excel | Excel Discussion (Misc queries) | |||
VSTO .net - Adding a Usercontrol unto Worksheet | Excel Programming |