Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl.ocx
Was looking forward to start implementing this in my UIs.
It also have another function to check if a TreeNode is found inside tree or not.
Sheet and workbook along with starting cell are all variables to be passed by caller.
For now, the form name is hard-coded as FrmLL, but the plan is to make it variable through passed argument.
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.codes
Linkedin LoginCell0_0, Optional Wb = "This", Optional Shee = "Active"
or
TrText, Optional ParentKey = ""
or
TrText, Optional ParentKey = ""
Sheet2TreeView_v1 "AG1", , "Data"
Where AG1 is the cell starting of 3 columns, having headers in Row1
Data is the sheet name
Where AG1 is the cell starting of 3 columns, having headers in Row1
Data is the sheet name
Views 3
Downloads 0
CodeID
DB ID

ANmarAmdeen
777
Revisions
v1.0
Thursday
August
7
2025
Codes Required 0

Similar codes

Recent 4 by ANmarAmdeen 4

Random Codes 4
