LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Should I use Excel or the OWC11.spreadsheet control in a web page? XP Excel Programming 0 May 23rd 08 01:15 PM
Save Control To Userform Toolbox [email protected] Excel Programming 4 August 12th 07 01:40 PM
control toolbox and userform toolbars in XL 03 Dave F[_2_] Excel Discussion (Misc queries) 2 August 8th 07 08:04 AM
How to turn off control toolbox while showing a userform Noah Excel Programming 0 February 27th 06 02:11 PM
Control Toolbox does not appear when trying to design a Userform! [email protected] Excel Programming 7 January 23rd 06 01:40 PM


All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"