Does anyone know if its possible to create a userform with
a digram that outlines a tree structure. Similar to the
tree structure you see in the VBA in the project windows.
For example I want to be able to build a tree structure
for cell dependents to digram circularity in cells.

thanku

There is a tree control. Right click on the toolbox, select additional
controls, and scroll down to it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ExcelMonkey" wrote in message
...
Does anyone know if its possible to create a userform with
a digram that outlines a tree structure. Similar to the
tree structure you see in the VBA in the project windows.
For example I want to be able to build a tree structure
for cell dependents to digram circularity in cells.

thanku

And he/she can find an example using this control he
http://www.erlandsendata.no/english/...nloaduserforms

--
Ole P.


Bob Phillips wrote:
There is a tree control. Right click on the toolbox, select additional
controls, and scroll down to it.

Thanks.
-----Original Message-----
And he/she can find an example using this control he
http://www.erlandsendata.no/english/index.php?
d=endownloaduserforms

--
Ole P.


Bob Phillips wrote:
There is a tree control. Right click on the toolbox,
select additional
controls, and scroll down to it.

.

There's a circularity tester with full routing diagrams of the circular
paths in the XspandXL add-in on my site. It's not a trivial exercise!

Robin Hammond
www.enhanceddatasystems.com

"ExcelMonkey" wrote in message
...
Thanks.
-----Original Message-----
And he/she can find an example using this control he
http://www.erlandsendata.no/english/index.php?
d=endownloaduserforms

--
Ole P.


Bob Phillips wrote:
There is a tree control. Right click on the toolbox,
select additional
controls, and scroll down to it.

.