1: select box==>insert==>field==>custom property
2: if all 3 shapes in a group, yes but you need to define the relationship at design time
ie....1+2*3==>4 is the designed in algorithm....1*2+3==>4 is an entirely different shape
(if you want to get real slick...you might try 2007 and do the user defined functions...aka some
custom properties to define how all the shape values are brought together).
if not in a group, this this gets a whole lot more complicated if not impossible.
There is no real nice way for 2 unrelated shapes to become aware of each other without writing VBA or
C code. You could do some special stuff just for your solution...but would be tediuos and only
for that solution. for example, some template with a bunch of shapes and VBA just to make the
unrelated shapes work together.
Another way is tie drawing to excell and work thru excell against the unrelated shapes then pipe
result back into drawing.
good luck
