Create Tree from 3 columns (Sheet2Tree)

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.

CodeFunctionName What is this?

Public

Tested

Original Work

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 Mydev.net

Linkedin Login

Cell0_0, Optional Wb = "This", Optional Shee = "Active"
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

Views 3

Downloads 0

CodeID
DB ID

Codes Required 0

Similar codes

Recent 4 by ANmarAmdeen 4

Random Codes 4