Organization Chart

[toocold]

Good morning,

Is it possible to insert an organization chart, add co-workers, subordinates, etc through VBA? If so, does anyone have some sample code that could get me started?

Thanks,
tc

[Toadums]

Why not just use visio?

Also, i dont get why you would need to use VBA...couldnt you just like click D1 and enter what ever their name is?

[toocold]

Why not visio - I have never used it so I am not sure how.

Why VBA - because I wanted to make it dynamic. I have about 20 different products that each consist of a number of sub-products. These sub-products may also have components. Right now it is all in table format but I have been asked to look at doing it as org charts to show how things are related.

Basically, I would like to be able to let a user select a product and then have vba populate an org chart based on the info in the table for a particular product. This product may only have one subordinate or it may have 10. Is this possible?

Thanks in advance,
tc