I want to create an Organization Chart in Excel through VBA coding. I have tried a lot using the Shape, Diagram objects but have not been able to catch the selection of a particular node. Can anybody help me with this problem?

Either catching the even of selection of the nodes or a new method altogether to create Organization Charts.

Cheers,

Mangesh