Structure chart with Userform - Link little connectors by a larger and single connector

[Doflamingo]

Hi all, I'm trying to find the lines of code that would allow me to connect the little connectors of the row 5 to a larger one

Here is how works the userform I've created

The commandbutton1 allows to put the elements of the textboxes 1, 2 and 3 in the listbox 1 and 2. You can add as many items as you want in the listboxes.

The commandbutton2 allows to integrate in the excel sheet the items included in the listbox 1 and 2

The commandbutton3 allows to locate at the exact middle the name of the enterprise, no matter the number of holders wich are the items included in the listbox1

The commandbutton 5 and 6 don’t work currently, it will be for an other project

The commandbutton 7 allows to display what the combobox 2 contains

Here you can see a screenshot of the userform I have created
Page 1 https://www.dropbox.com/s/cbbsr52p5ekc0lo/Userform page 1.png?dl=0
Page 2 https://www.dropbox.com/s/sutg6saz4qgabi1/Userform page 2.png?dl=0

Here you can see what the userform allows me to create

https://www.dropbox.com/s/rkdsyviw9zq2v8j/What the userform allows to display currently.png?dl=0

And here what I’m looking for
https://www.dropbox.com/s/gxluslntdpntj0l/What I would like.png?dl=0

Currently, I’m looking a code to make appear a large connector which would link the little connectors of the items included in the listbox1, that are the first and last name of the holder at the row 5

Feel free to download the excel file J, here is the link
https://www.dropbox.com/s/cfu5o39ihruamh9/Structure Chart with Userform.xlsm?dl=0

Any ideas ?

 

[Worf]

Did you finish this project?

 

[Doflamingo]

Hello @Worf,

Yes I've found the answer in that thread [h=1]How to change the lenght of a connector ?[/h]