TreeView on Userform (VBA (any))

Topic

New Reply

Does anyone have some sample code for populating a treeview and/or an imagelist control on a Userform. My treeview is a list of object names which I can create, but I also want to add an image to each node: a small square which is the same color as the object. For example, I might have a Fruit node which has apples and bananas as children. I want to create a small square at run-time which is colored red for the apple image and yellow for the banana image. I need to create the images at run-time because the user can color the objects with any RGB color before displaying the userform. TIA –Sam

Reply | Quote

Replies

Have a look here @ Colo’s example

http://puremis.net/excel/code/080.shtml%5B/url%5D

(Above URL made clickable by HansV)

Reply | Quote

Thanks Ivan & Alan, these are very nice code examples that I hadn’t found. Colo’s example looks like my solution, but I have a color column instead of an image column, so I have to create the images at run-time. I’ll try to remember to post my code, but right now it is not on this network. Thanks! –Sam

Reply | Quote

Thanks Ivan & Alan, these are very nice code examples that I hadn’t found. Colo’s example looks like my solution, but I have a color column instead of an image column, so I have to create the images at run-time. I’ll try to remember to post my code, but right now it is not on this network. Thanks! –Sam

Reply | Quote

Have a look here @ Colo’s example

http://puremis.net/excel/code/080.shtml%5B/url%5D

(Above URL made clickable by HansV)

Reply | Quote

Sammy

I found this article “Making the Most of the VB TreeView Control” to be very informative. Don’t recall if it deals with graphics though, but certainly deals with runtime population.

Alan

Reply | Quote

Sammy

I found this article “Making the Most of the VB TreeView Control” to be very informative. Don’t recall if it deals with graphics though, but certainly deals with runtime population.

Alan

Reply | Quote