Home » Blogs » deepakjipaulson's blog

Tree View in Excel

Submitted by deepakjipaulson on 28 November, 2011 - 14:35

Hi Nick,

Could u pls. assist with the below queries

1. When this file is closed and opened
the form control shrinks & expands- becomes steady only after a couple of scroll

2. When a particular item (parent/child) is selected
the same should get linked to a particular cell in the ctrl sheet

Thanks
Deepak Ji Paulson

AttachmentSize
tree view.xlsx8.51 KB
tree view.xlsm17.13 KB
»

TreeView & Hyperlink in Pivot

Submitted by deepakjipaulson on 28 November, 2011 - 14:36.

Is there any 1 who can crack this ????????

Thanks

»
Vishesh's picture

TreeView doesn't work

Submitted by Vishesh on 28 November, 2011 - 17:35.

TreeView doesn't work perfectly on Excel Sheet. It resizes and changes position on opening and closing the Excel file.

Please see url
http://excelexperts.com/tree-view-excel-2007

Also, if you really want to have a treeview then have it on a form and display the form at a certain location.

»

How could I do that.. Could u

Submitted by deepakjipaulson on 29 November, 2011 - 10:18.

How could I do that.. Could u pls. provide the VBA code / sample file..

Thanks

»