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


Board Regular
Apr 16, 2019
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 page 1.png?dl=0
Page 2 page 2.png?dl=0

Here you can see what the userform allows me to create the userform allows to display currently.png?dl=0

And here what I’m looking for 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 Chart with Userform.xlsm?dl=0

Any ideas ?:confused:

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics