Error Whilst Updating Nodes On A Treeview

Hi everyone!

I currently have a large workbook with many worksheets. To make life a little bit simpler for myself, I decided to create a navigation bar out of a TreeView control.

This control has been working fine since I built it some time ago. However, today I decided to update the TreeView control by changing some of the parent/child node names and references. This is where my error started to occur.

I keep receiving an error message regarding the key not being unique, but my previous setup had non-unique keys too with no issue, as they were children of separate parents (as they are in this case too!). Hence I can't understand why I am getting an error. I know that I can't have 2 children with the same name belonging to a single parent, but I was of the opinion that this wasn't an issue if the children had different parents.

In the attachment, I have provided the old setup ("TreeViewSetup (Before)") and the new one ("TreeViewSetup (After)"). You will notice that the old navigation bar builds without issue, but the new one fails once I reach the "Navy" section. And yes, "Navy" and "Air Force" are both replicas of the "Army" section, so it doesn't make sense that the code crashes when it gets to Navy but not when it is building the "Army" menu.

Thanks for any help I can get

Never mind, I solved it on my own.

When I first setup the navigation bar, I must have been more intelligent than I am now, as I was smart enough then to realise thatto create duplicate keys I need to add a redundant space to the duplicate so that it only appears to be identical.

I hope this helps someone else in future