Creating Tree Views in Excel

[Guest]

I have taken over a project that automatically creates a tree view based on a
criteria selection by the user of the tool. The view shows a list of tasks a
person has to do in a certain job. The users have requested the list to have
the capability of word wrap. I’ve tried several things, but cannot get it to
work. Is there a way or a setting in the tree object to keep it a certain
width to make the words wrap?

Thanks for your help!

 

[Guest]

It's a TreeCtrl object used on a form. It's was inserted directly onto a
sheet. There is a function that fills in the data.

 

[NickHK]

JD,
How are you achieving a tree view in Excel ?

NickHK

 

[NickHK]

JD,
Don't think's possible, as you never see that behaviour in Explorer.
If the effect is that important, you could draw you own.

NickHK