C
Casey
Hi,
I am trying to generate org charts from Excel spreadsheets. My
problem is that when I update the Prop.Name and Prop.Title for the
shapes, the updated changes are not appearing in the shapes. If I
manually open the shapesheet window and hit enter in the cell, then it
will change, or if I manually change it through the 'Properties'
window, it will change. Is there any way to do this through VBA ?
Maybe I can trigger the cell using the formulachange event but I'm not
really sure about what the code would look like. I'm using the
standard org chart shapes that come with Visio, so the custom property
settings are unchanged. Any thoughts and ideas (especially sample
code ^_^) would be most appreciated.
Thanks,
Casey
I am trying to generate org charts from Excel spreadsheets. My
problem is that when I update the Prop.Name and Prop.Title for the
shapes, the updated changes are not appearing in the shapes. If I
manually open the shapesheet window and hit enter in the cell, then it
will change, or if I manually change it through the 'Properties'
window, it will change. Is there any way to do this through VBA ?
Maybe I can trigger the cell using the formulachange event but I'm not
really sure about what the code would look like. I'm using the
standard org chart shapes that come with Visio, so the custom property
settings are unchanged. Any thoughts and ideas (especially sample
code ^_^) would be most appreciated.
Thanks,
Casey