Making ActiveX control for Excel 2003

[mech3]

Hello,
I am making ActiveX control project in VB6. It creates .ocx file I can add this control in other projects but while adding it to excel 2003 as a activex control, it's content doesn't show. It's only appearing by borders. However many other activex control in my computer can be added to excel. Can't VB6 's activex controls be added to excel?
thanks

[LaVolpe]

Welcome to the forums.

I am willing to bet that it something within your usercontrol that is the problem. We'd have no way of knowing without more detailed info.

1. Suggest looking at code that may be using the Ambient.UserMode to turn on/off functions. Note that not all ocx containers will eport Ambient.UserMode the same way, if at all.

2. Suggest looking at code where you may be using On Error Resume Next which may be hiding an error you should be aware of.

[mech3]

thanks for the answer LaVolpe...
I created a ActiveX Control project.
I have added just a button on the usercontrol...there is no code.
I am making it .ocx from the file menu.
Should I add a code in it?
If there is a sample project that would be very useful...
thank you very much...

[LaVolpe]

So, your ocx is just a container for the VB button? And when you add to your Excel app, the button is not visible? You have no other code that is toggling the button's visibility? Maybe a small screenshot of what the button looks like when run in a VB project and what it looks like run in your Excel.

One more question. Is this happening on the same pc that the ocx was created/compiled on?

[mech3]

Compiling activex control project. It has a button which shows a messagebox:




In another exe project I am adding that ocx as a component:




Works fine:




However When I add in to excel as a ActiveX Control:




It looks like this:




and all of these on same computer...

[mech3]

I have solved the problem with this page: http://channel9.msdn.com/Blogs/funky...rms-Toolkit-20

[mech3]

Compiling activex control project. It has a button which shows a messagebox:




In another exe project I am adding that ocx as a component:




Works fine:




However When I add in to excel as a ActiveX Control:




It looks like this:




and all of these on same computer...

I still need an help about the making excel control in VB6.

thanks...

[mech3]

it is solved when I switch off the design mode in Excel...