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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...