ActiveX control with chart
 

Hi Jon

Did you ever resolve this issue you discussed with Erich Neuwirth? I
have an almost identical problem: I've OLEembedded various activex
picture controls on worksheets, only to find I can't load images into
them, see images in them, or see their properties and methods.

I can activate an object using MyObject.Active, but this seems to
change nothing. I can select an OLEObject with MyObject.Select, but
then using With Selection, the tipswindow only shows the sheet
properties, not the OLEobject properties.

As you say, it seems like all Excel can see is the Shape that encloses
the control. I'd be extremely grateful for any help from anyone.



Jon Peltier wrote:
[b]Hi Erich -

Last year I installed a third party ActiveX chart control, thinking
I'd
use it for some funky new charts. Five minutes ago I used it for the
first time, to get a handle on your question. I insert the chart
using
Insert menu Object, and selecting it from the list.

I could activate the control's dialog with the right button, but
otherwise I couldn't select or activate the control. The best I could
do
in vba was to change its position (activesheet.shapes(1).top and
.left)
and its size (.width and .height) but not its aspect ratio.

Then I switched to design mode (click the quaint T-square and
triangle
button on Excel's Visual Basic command bar). This enabled me to
select
the objects, move and size it with the mouse, and change the aspect
ratio.

Interestingly, as soon as I ran something from the VB Editor, Excel
exited design mode, and VB was unable to do very much. Excel created
a
reference to the control, but for the life of me, I could see
nothing
that talked of a container for the control. I suspect the container
is
just a nondescript Shape.

Seems like all Excel can see is the Shape that encloses the control.

- Jon



--
Tanihera
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message953530.html

ActiveX control with chart
 

A blast from the past. I suspect I gave up on the ActiveX charting control,
since I don't remember anything further.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Tanihera" wrote in message
...

Hi Jon

Did you ever resolve this issue you discussed with Erich Neuwirth? I
have an almost identical problem: I've OLEembedded various activex
picture controls on worksheets, only to find I can't load images into
them, see images in them, or see their properties and methods.

I can activate an object using MyObject.Active, but this seems to
change nothing. I can select an OLEObject with MyObject.Select, but
then using With Selection, the tipswindow only shows the sheet
properties, not the OLEobject properties.

As you say, it seems like all Excel can see is the Shape that encloses
the control. I'd be extremely grateful for any help from anyone.



Jon Peltier wrote:
[b]Hi Erich -

Last year I installed a third party ActiveX chart control, thinking
I'd
use it for some funky new charts. Five minutes ago I used it for the
first time, to get a handle on your question. I insert the chart
using
Insert menu Object, and selecting it from the list.

I could activate the control's dialog with the right button, but
otherwise I couldn't select or activate the control. The best I could
do
in vba was to change its position (activesheet.shapes(1).top and
.left)
and its size (.width and .height) but not its aspect ratio.

Then I switched to design mode (click the quaint T-square and
triangle
button on Excel's Visual Basic command bar). This enabled me to
select
the objects, move and size it with the mouse, and change the aspect
ratio.

Interestingly, as soon as I ran something from the VB Editor, Excel
exited design mode, and VB was unable to do very much. Excel created
a
reference to the control, but for the life of me, I could see
nothing
that talked of a container for the control. I suspect the container
is
just a nondescript Shape.

Seems like all Excel can see is the Shape that encloses the control.

- Jon



--
Tanihera
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message953530.html