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

Doflamingo

Board Regular
Joined
Apr 16, 2019
Messages
238
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 ?:confused:
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,096,303
Messages
5,449,560
Members
405,571
Latest member
Flux1234

This Week's Hot Topics

Top