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.top + ActiveCell.Offset(1, 0).top) / 2 Set con =...

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 +...

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

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 https://www.dropbox.com/s/95uvji7ageuumy9/Connector%20flaw.png?dl=0 and what I would like https://www.dropbox.com/s/c49g3t9v9xzlhf2/connector%20proper.png?dl=0...

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

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

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

I am trying to show / hide some lines (basically to show that this area is Not applicable) Screenshot is here: https://prominent.wetransfer.com/downloads/6b62206a80eab4f41513892cf4499e9e20180522162354/f9d0a56871addac95a4eecc83dea5b2c20180522162354/7d9101 Sub CheckBox22_Change() If...

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

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

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

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

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

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

Hope someone can help How do you identify the connectors linked to a shape in vba ? rgds Andy Page