Transfer ALL nodes from a UserForm TreeView into a TreeView on a worksheet with VBA

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!

Not sure if you mean you want to Export to a TreeView control on a worksheet, or just export the data to a worksheet.

If the latter, I downloaded a marvellous bit of code from here to load a 'treeview' (actually just a formatted tree like list on a worksheet) to a treeview.

I also needed to export that data back to a worksheet - so I used the example to learn the various properties of a treeview.

Attachment contains both the original code from the example to import from and Excel sheet and my procedure to Export back to an excel sheet.