| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba and orgchart shapes
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba and orgchart shapes
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 | | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | | |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba and orgchart shapes
Selection.Interior.Color = 12632256
or am I missing something? -- Jim Rech Excel MVP "Luc Benninger" <lb (at) zignet.ch wrote in message ... | 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 | | | | | | | | |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba and orgchart shapes
you aren't... thanks!
Luc "Jim Rech" wrote in message ... Selection.Interior.Color = 12632256 or am I missing something? -- Jim Rech Excel MVP "Luc Benninger" <lb (at) zignet.ch wrote in message ... | 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 | | | | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
| Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
| Excel- orgchart and databases | Charts and Charting in Excel | |||
| When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
| excel macro to update visio orgchart | Excel Discussion (Misc queries) | |||
Linear Mode
