View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Luc Benninger Luc Benninger is offline
external usenet poster
 
Posts: 14
Default vba and orgchart shapes

no, it don't. (well, or am i missing something??)
i just want vba to change the fill color of the currently selected shape(s)
in a diagram.
in word and powerpoint the selection object has a childshaperange property
for doing this. but excel...??
Luc

"Jim Rech" wrote in message
...
Does Selection.Name and/or Typename(Selection) help?

--
Jim Rech
Excel MVP
"Luc Benninger" <lb (at) zignet.ch wrote in message
...
| how can I detect with vba what shapes in an organization chart diagram
are
| currently selected? if text in such a shape is selected I can get the
shape
| reference with the parent property. but what can I do if one or more
shapes
| are selected?
| using excel xp/2003.
| thanks a lot, Luc
|
|