VBA UI UX-16: How to use powerful TreeView Control in Excel UserForm 

God bless you, I can only imagine how much time I took you to learn all this trick and skills

This is absolutely awesome! I have tried to find an example of this for a long time with no luck. You have explained it very well in your video, I think I finally have a basis to start on a Treeview. Thank you for all your amazing video content.

Excellent examples and explanation. Easy to follow

Easy to understand and very helpful - thank you

Achi you are GENIUS.

Amazing! You are a wizard, and a generous one at that :)

Excelente conteúdo, muito obrigado por compartilhar o seu conhecimento.

another great episode thanks!

Great tutorial. Thank you so much

Its a great explanation. Thank you.

thanks again Pamai

This is really informative. thanks for sharing your knowledge.

Brilliant! Thanks

Thanks for another very useful video

Excellent. Thank you very much

Wow your channel is just amazing.

Thanks for the exemple!

Genius! Sometimes we can find gold in youtube and your videos are gold. Thanks! I would like to learn how to parse Excel formulas like that. Are you going to discuss that?

Great tutoria

This is superb.🥰😍

Great training. Thanks so much. I am thinking Customers: Invoices: Invoice Items. I will try to put it together for a training. Thanks again

thank you

great code.. good contribution.

Thanks

excellente

Good project Sir

Hi Lung Pamai! Thank you for your videos, they are helping me a lot! I'm solving how to click on parent checkbox for having all children checkboxes clicked? There is a video you handled this topic? Many thanks.

Very helpful tutorial! I believe the way it's set up now however is that if there's a city with the same name in another country, it'll only add it once. What do you suggest as a workaround for this? I thought about setting the key to the full path of each item, e.g. the key for New York in USA would be "North America\USA\New York City", and the key for New York in another country would be "North America\Canada\New York City". It's obviously a not realistic bad example but I hope you know what I mean. Let me know your thoughts.

Hi, that was very generous of you,, thank you for your effort. Is there a way to auto extend the nodes without clicking on them one by one?

Hi Lung Pamai! First of all, thank you so much for your high quality videos! It's helping me a lot in my projects. They are motivating me to start programming and I am really enjoying it =) I have one question regarding multiple users in a single UserForm in Excel. Is it feasible to have around 4 users o the same userform to input, update and delete data from the same workbook? I did not test it yet but it could be a problem according to some search in internet. In my case, all users have the 365 license. Thanks a lot!

The Video is very helpful, it would be nice if there was a description when an action is executed when child is clicked

Good afternoon, please post a video hoy I can search for a data within a treeview

Hello, it's a great explanation, thanks, sorry the link provided is no longer available?

what is the maximum number of nodes this control can have?

goodone

Do you have any videos on loading a Treeview directly from a sql recordset?

Hi, is it possible to select a node then it will use the selected node as a filter to another table? Then it will show for example the sales of that node.

Where can I download the Formula Treeview utility you have showed at the start of the video? This could be really useful! Keep up the great work, your videos are a great learning tool!

hmmm what if I have two keys of the same name, but under different parents? It's throwing an error. Thanks for the great help.

Hello sir, 'm looking for .NET c# or vb how to add child to parent by specifying the parent id or name. please guide. thanks.

Hello, thank you for the tutorial. I can't seem to be able to find it on your website. Could you please PM me the link?

Nice Lung Pamai! Is it supported both in 32 and 64 bit Excel?

Download for this item does not appear to be available?

I'm attempting to apply this to my own workbook, but each time I do it, re-do it, lookup new methods, no matter what I try I seem to keep getting this "User-defined type not defined" compile error. I've followed the video step for step with the only real difference being the number of sheets I have in my file and the columns I am using (in this case columns A through C). I'm currently sitting at time frame 24:34+ after entering the sub name, trying to run it the exact same way he did. Is this a common issue for anyone else? Code: Option Explicit Public EntityOwnershipData() As Variant Sub laodTvDATA() Dim dic As Scripting.Dictionary Dim dkey As Variant Dim ArrIndx As Long Set dic = CreateObject("Scripting.Dictionary") EntityOwnershipData = Range("A2:B121") UserForm1.TreeView1.Nodes.Add , , "Primary", "Primary" For ArrIndx = 1 To UBound(EntityOwnershipData) If Not dic.Exists(LCase(EntityOwnershipData(Arr.Indx, 1))) Then dic.Add LCase(EntityOwnershipData(Arr.Indx, 1)), Nothing UserForm1.TreeView1.Nodes.Add "Primary", tvwChild, EntityOwnershipData(ArrIndx, 1), EntityOwnershipData(ArrIndx, 1) End If Next ArrIndx End Sub Command button code: Private Sub CommandButton5_Click() With Me.TreeView1 .Appearance = ccFlat .CheckBoxes = True .LineStyle = tvwRootLines .Nodes.Clear End With laodTvDATA End Sub Let me know if anyone else is having this issue or if you need further information about the file to understand my situation.

With all your UI prowess, have you found a way to change colors of TreeView Controls?

Como fazer Treeview interagir com multipage?

I need source please

Hi great video, and amasing what you can do with treeview. But i get the Error Run-Time Error '35603' Invalid Key every time. Sub GetPVData() Dim dic As Scripting.Dictionary Dim dKey As Variant Dim ArrIndex As Long Set dic = CreateObject("Scripting.Dictionary") PVData = Range("C4:e500") UserForm1.TreeView1.Nodes.Add , , "PV", "PV" For ArrIndex = 1 To UBound(PVData) If Not dic.Exists(LCase(PVData(ArrIndex, 1))) Then dic.Add LCase(PVData(ArrIndex, 1)), Nothing UserForm1.TreeView1.Nodes.Add "PV", tvwChild, PVData(ArrIndex, 1), PVData(ArrIndex, 1) End If Next ArrIndex End Sub Can someone maybee assist what is wrong?

I'm sorry. You're explaining to yourself not to others

thank you

Thanks

Thanks