Shapes question.

[dreid1011]

Good morning,

I am building a tech tree/flow chart and I had an idea to make it a little more user friendly as it may become quite convoluted down the road. The idea would be to highlight/color change any connected lines/arrows when selecting a specific point(shape) in the chart.

I tried a little bit of searching but Google is no help, and I was just wanting to get an idea of how involved this could be before I attempt to take it on, if it's even possible.

Any help is much appreciated.

Thank you

 

[Yongle]

The problem to overcome is defining a relationships between the Shape and its connections
IMHO trying to do this based on shape proximity would be fraught with problems

The way I would approach it would be to create a lookup table with the shape names across the top and a list of its connection below (or perhaps named ranges)

Mousemove over shape could be then used
to .... remove all previous highlights
and ...highlight connections based on lookup values

You could test this approach to see how onerous it is

 

[dreid1011]

That is an idea. I will see how it goes, thank you.