View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shoeless shoeless is offline
external usenet poster
 
Posts: 9
Default Excel 2010 Charting in Userform - Can't Access OWC11 Control from Toolbox??

Good people,

I am stumped...

Chronology:
I use VBA to perform many calculations
I store these calculations in Access
I do all this using the VBE from Excel
I retrieve values from Access, and then store them in local arrays
I bind these arrays to ChartSpaces within UserForms
I've done this successfully using OWC11 and Excel 2007 on a 32-bit version of Vista
I've upgraded Windows 7 64-bit and to Office 2010
Immediately I start getting errors :'( about references, and some additional keywords I need to use for my code to work on a 64-bit
I updated the references/libraries, and modified the code to run in Office 2010 on 64-bit Windows 7 (e.g. adding the PtrSafe keyword to declaration statements).
I can now run calculation routines successfully
When I open up the UserForms, however, the ChartSpaces are missing??
I make sure OWC11 is referenced correctly; I can browse it within the object browser, so everything seems fine to me...
I try to add "additional controls..." to the toolbox form, but I cannot find the ChartSpace control under the list of available controls :''(


Can anyone help me out?
If I can just get the ChartSpace control to the toolbox form, then I
can just re-add the required ChartSpaces that my code references...

I have not been able to solve this problem on my own, and I was unable
to find a solution form internet searches. I am at a loss; any help
would be greatly appreciated,
B