Results 1 to 3 of 3

Thread: Structure chart with Userform - Link little connectors by a larger and single connector
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2019
    Posts
    131
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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/cbbsr52p5e...e%201.png?dl=0
    Page 2 https://www.dropbox.com/s/sutg6saz4q...e%202.png?dl=0

    Here you can see what the userform allows me to create

    https://www.dropbox.com/s/rkdsyviw9z...ently.png?dl=0

    And here what Iím looking for
    https://www.dropbox.com/s/gxluslntdp...0like.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/cfu5o39ihr...form.xlsm?dl=0

    Any ideas ?

  2. #2
    Board Regular Worf's Avatar
    Join Date
    Oct 2011
    Location
    Rio, Brazil
    Posts
    3,617
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    2 Thread(s)

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

    Did you finish this project?
    Excel 2013 / Windows 8.1 (home)
    Excel 2013 / windows 7 (work)


  3. #3
    Board Regular
    Join Date
    Apr 2019
    Posts
    131
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Hello @Worf,

    Yes I've found the answer in that thread How to change the lenght of a connector ?


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •