connectors

  1. D

    Deactivate connectors from shapes

    Hi all :) Does anyone know a VBA code that would allow me to deactivate connectors from shapes. Here see an example https://www.dropbox.com/s/e7m5qdre9m1riwp/Untitled.png?dl=0 Because what I would like is to turn the shapes at 180 degrees without moving the connectors. That's why I'm...
  2. D

    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...
  3. D

    Linking connectors by a larger connector

    Hi all, I'm trying to find the lines of code to link the little connectors to a single one. Here is what I have currently, where the cells above represent the items b of a listbox 2, with a connector for each item, then below there is a cell that contain the value of a textbox. Currently...
  4. L

    Connectors

    Hi, I am trying to create elbow connectors between two images in the sheet, i prefer it connecting Bottom center of image 1 to Top center of image 2, so that i appears as a tree structure. when i write code it creates between right center of image 1 to left center of image 2, something like it...
  5. H

    Joining a shape with multiple connectors - beginConnect method

    hi, i am new to VBA and i have written this code: For i = 1 To NoOfConnectors BConnectors(NoOfConnectors).ConnectorFormat.BeginConnect Shape1, CLng(5) Next Here, BConnectors is an array of connectors which i want to connect to Shape1. The problem is when I run this code, only the last...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top