How do I create a shape data that sums the values of connected shapes' data?

Started by orange12, September 22, 2017, 06:27:31 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

orange12

Hello, I'm running Visio 2013 and trying to create a power distribution diagram that shows a power supply unit (PSU) connected to multiple loads. The trick is, I want the PSU to have a 'Watts' shape data with a value field that automatically sums the 'Watts' shape data from all connected loads. Furthermore, if a connection between a load and the PSU is removed, I want the PSU's shape data to update accordingly.

I imagine this would be a macro but what would be the trigger event and where would I put the macro call within the PSU's Shapesheet?

Thanks for the help.

JuneTheSecond

I think it possible, but I don't remember the details.
My stencils in my home page are too complicated for your purpose.
Unfortunately, I forgot how the first stage that might be proper for your requirement.
Best Regards,

Junichi Yoda
http://june.minibird.jp/

Yacine

@Junichi,
no your stencils are not too complicated. I demonstrated that in this post: http://visguy.com/vgforum/index.php?topic=7994.0

@Orange12, have a look at the a.m. topic, in the macros you'll see how to sum the values.

Regards,
Y.
Yacine