Organization chart with VBA – Part 3

[Worf]

At cell B30, it should be CHILD5.

 

[AndewY]

Thanks Worf and sorry for that - it was my silly mistake.
Your workfile works great now! thanks again! .


Just one final question.
Which lines of the macro would I need to change/ adjust if my description contains more than 10 characters.
Or is there a way to have the width of the box be conditioned on the max count of characters (max-len?) within the data table (fshap)

I was testing this and the boxes on my chart start overlapping with "desc extra super long"

Here's a screenshot of what my chart looks like with the above.
Once again, thank you so much - this is a really brilliant workbook.

 

[Worf]

Some new code is required for the horizontal adjustments, I will write it.

I have been busy these days so it may take a while…

 

[AndewY]

Hi Worf,

Thank you so much again for being so generously helpful.
No rush in getting this new code added and I'm sure everyone (including me) following and using your workbook will be looking forward to it.

Thanks again!!!!

 

[Worf]

I posted a solution:

Organization Chart with VBA – Part 4

A request came up to accommodate wide boxes. Since it would be complicated to modify the core algorithm, I opted to prepare an interface where the user will be able to adjust the chart to their liking. You will be presented with a basic chart...

www.mrexcel.com

 

[AndewY]

Thanks Worf for the improved update. Very much appreciated