1. D

    top vertical connector for active cell instead of left horizontal connector

    Hello all, Here is the code for any active cell to get left connector. 'left direction l = (ActiveCell.Offset(0, -1).Left) r = (ActiveCell.Offset(0, 0).Left) t = ( + ActiveCell.Offset(1, 0).top) / 2 Set con =...
  2. D

    Vertical connector with specific lenght

    Dear All, Here is the code for horizontal connector for an active cell where the connector displays at the middle of that cell. Its lenght is half of the previous cell + current cell + half of the next cell. Dante gave me kindly those lines of code. l = (ActiveCell.Offset(0, -1).Left +...
  3. D

    How to change the lenght of a connector ?

    Dear all, Does anyone know how to adapt the lenght of a connector. Here the present code allow to draw a connector for the above border of a current cell, but I would like it a little bit longer. AddConnector(msoConnectorStraight, .Offset(, 1).Left, _ .Top + .Height / 17...
  4. D

    Specific cell with 2 connectors, up and dow

    Hi all, I try to find the lines of code that would allow me to put the right up connector to a cell Here you can see what I have and what I would like
  5. P

    Place vertical connector in the middle of cells in column

    I wish to programatically to add a connector in the center of the cells in range B5:B11. I do have the following code below, but how to place the connector in the center (not left)? Sub AddArrow() Dim shp As Shape Set shp = ActiveSheet.Shapes.AddConnector(msoConnectorStraight...
  6. G

    Connector arrows that stick to cells: How to?

    I would like to find a way to draw arrows between cells in such a way that the arrow stays connected to those cells even when one of the cells is moved. I am using Excel 2010. If I simply draw an arrow (Insert > Shapes >Arrow) between two cells, then it remains stuck to that cell if I resize...
  7. Small Paul

    Excel 2013 to Salesforce Professional Connector

    Hi All We hold our data in Salesforce Professional. Every day I have to go through the process (in Salesforce) of exporting .csv reports to Excel 2013 to then manipulate the data. I am presently in the process of automating the Excel part with macros. Can anybody advise whether there is a...
  8. E

    Check Box to hide/show a line thru a series of cells

    I am trying to show / hide some lines (basically to show that this area is Not applicable) Screenshot is here: Sub CheckBox22_Change() If...
  9. J it right for this?

    Hello, I am trying to create a wire analysis application and I'm not sure if Excel the right choice for this. I will try to explain what it is that I am trying to accomplish. Using imported data from a csv file, I want to be able to trace a circuit from end-to-end. Sometimes this will be...
  10. J


    Hi, I have a large spreadsheet and I am sent information to update equipment numbers and other information contained within it. I can provide a sample of the spreadsheet. Staff send in a copy of the information with manually highlighted fields and changed equipment names and numbers etc. I have...
  11. M

    Determine connector on shape and move the connector-begin (or end)

    Hi everybody, I would like to write a VBA for moving the begin or end of a connector to the next possible anchor on the connected shape (clockwise or anticlockise; this is not relevant ). The user shoud click on the shape (not on the connector) and than (when the VBA is processed) the...
  12. J

    VBA Connect to MYSQL Driver Error

    Hi, I am trying to connect to a hosted MySQL database running 5.0.96 so I have installed the latest driver from MySQL site "Connector/ODBC 5.2.6". But I get this error: [Microsoft][ODBC Manager] Data source name not found and no default driver specified. I am able to connect if I use the ODBC...
  13. U

    PowerPivot and mySQL - is it really impossible?

    I've trawled the depths of Google (beyond page 20 of search results!) to try and find a solution to my current problem. Given that I haven't found a solution I'm tempted to believe that it's impossible but being an eternal optimist I've now decided to post something in here. Outline of what I...
  14. D

    PowerPivot and MS SQL Azure

    Has anyone tried to use PowerPivot with MS SQL on the Azure cloud? If not, would anyone like to test it with me?
  15. A

    Shape to Connectors

    Hope someone can help How do you identify the connectors linked to a shape in vba ? rgds Andy Page
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
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 "".
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