ActiveX 2010 on Excel Form

[Jurgen]

Hello,
When I want to put TChart & TeeCommander in en Excel Form , I received the error: 'Element not Found'.
I can add the components on the Excel worksheets. The samples provided also work, But for some reason I can not get Tchart on a MSForm in an Office application.
I'm using version 2010.0.03 and Office 2010 on Windows 7 (with administrator rights)

Can you help me out?

regards,
Jurgen

[Yeray]

Hello Jurgen,

Can you add another ActiveX control in the same form where TChart fails?
If yes, can you please attach that simple example here?

[Jurgen]

Hello Yeray ,
Thanks for looking at my issue.
I can add other controls to that form, such as a simple commandbutton, but also a Windows Browser or Adobe Reader control.
I receive the error when adding a TChart, a TeeCommander etc to the form.
I can add a TChart in the worksheet.
sample workbook added in attachment. An .xlsm file was refused so I put it in a zip.

regards,
Jurgen

[Yeray]

Hello Jurgen,

Excuse us for the delayed reply.
Thanks for the worksheet example (that works fine) but we'd need the MSForms application example. I'm not an office expert and I'm not sure about what exactly is.

[Jurgen]

Hello,
With MSForms I just mean the UserForms you can add/create in Excel or any other MS Office Application.
Steps to make sure we are talking about the same:
* open Excel
* press ALT F11 to open the Visual Basic Editor
* In the menu , select Insert | UserForm
* On this Form, I can add the usual MS Form Objects (buttons etc), other objects as browser, pdf. But not a TChart
note: I did add a reference to TeeChart ActiveX Object Library

regards,
Jurgen

[Yeray]

Hello Jurgen,

Thanks for the steps. I could add a chart to the UserForm without problems.

UserForm.png (61.26 KiB) Viewed 7487 times

Libro1.zip

(11.54 KiB) Downloaded 583 times

I'm on Windows 7 x64, Office Professional 2010 (14.0.5128.5000) (32 bits), TeeChart AX 2010.0.0.3.