Tree-Like Horizontal Hierarchical List in Excel

[DocAElstein]

Hi
I do not think that there is any built in way to do this. I do not think there is any simple way to do this.
I think it could be done with a use of UserForms.
It would be a fairly long and complicated set of codlings behind a number of UserForms.
I do not think it would be too difficult for someone experienced in UserForms to do, but it would take them some time.
I don’t think anyone would be prepared to do this for you at a free help forum.

I personally cannot even give you a simplified workbook as a start point because my experience in UserForms is very small.

Possibly someone with a lot of experience with UserForms may be prepared to give you a simplified example, or , if you are lucky, someone may have already done something like this, and will pass you on a file.

The nearest that I have done to this is a something with a UserForm that works similarly to intellisense:
In this application of mine, in a UserForm you can start typing a word and then instantly a drop down list comes up with options from a list. The number of options reduce as you type more characters.
That is something different to what you are asking for, but it does demonstrate that you can arrange almost anything to be done using UserForms. This is because UserForms in VBA is similar to the Forms in Visual Basic. The programming that is Forms in Visual Basic was for many years the standard coding and workings behind many things and final applications as used and seen by the final user in Microsoft Windows.
The entire Excel spreadsheet itself could be thought of , crudely , in a very simplified sense, as a very complicated set of VBA UserForms or Visual Basic Forms.

That will all not be an immediate help, but may help put things into perspective.

Alan

( Edit, P.S:- Feel free to cross post your question elsewhere, but as always, please remember to respect any forum rules: This will usually mean just telling everyone, ( preferably by including a URL link ) , of everywhere else that you have posted.
I expect if you post at excelforum.com and mrexcel.com , then you will catch 95% of the Excel Expert audience )