Simple question that apparently has no simple answer: is it possible to transfer ALL of the nodes, parent, child or otherwise, and their arranged structure, from a userform treeview to a treeview on a worksheet?
I have a userform where people can build their own categories and subcategories in a treeview control, and once they've done all this, I need them to be able to save what they did somehow. I cannot use the Clone thing because it only deals with the parent nodes, and I need every single node to be transferred.
I'd be happy to copy the treeview if that would work, or something else. The end result just needs to be an exact replica of the userform treeview, placed on a worksheet in the workbook. Please tell me that this is possible. It seems ridiculous that it wouldn't be. But the internet is sadly lacking in regard to Treeviews in Excel. Every search I've run pretty much only pops up stuff for C# or Access. Help!
Bookmarks