create sheet on tree view selected node

Hello there, I really appreciate your help regarding of creating sheet based on the node value that is selected on tree view checkbox. I would like to create sheet based on the value the user selected in a tree view node. for example if I choose Australia>2214>20160005. it will create 2 sheets named "AU-2214-20160005"(Column D) and "AU-2214-20160005r"(with letter "r" included). I would like to attached sample workbook but it has a size limit,so I include image only of a Treeview Form and layout of my workbook then my sample code I used. It is possible to create multiple sheet if user selected multiple nodes?thanks for helping!

Please Login or Register  to view this content.