+ Reply to Thread
Results 1 to 3 of 3

Problem with connecting Freeform shapes

  1. #1
    Registered User
    Join Date
    05-23-2016
    Location
    India
    MS-Off Ver
    Office 16
    Posts
    2

    Problem with connecting Freeform shapes

    Hi,
    I'm working on a macro to automatically create shapes and connect them thereafter according to a list. In this process, each shape(in this case, a rectangle) might have a double digit number of connections. Therefore, I created a freeform shape in stead of the usual CurrentSheet.Shapes.AddShape(1,100,200, 200, 200) that creates an autoshape rectangle.

    This helped me by providing as many nodes as I required to make connections on each shape. However, these connections are cutting across the shapes and cannot be manually adjusted. When I tried to use the rerouteConnections command, the connections are made to the nearest node dislodging or eliminating the connections at these nodes. This is not desirable as I will be depicting more than one connection between two boxes according to the type of common property they share.

    Connections made between two autoshapes creates nodes within the elbow connector thereby making it adjustable manually. However, these nodes might or might not be present in freeform shape connections. Besides, as shown in the attachment, more than one connection is merged into the same line.

    Is it possible to overcome this problem? Alternatively, is it possible to introduce new nodes on an autoshape rectangle?

    Thanks in advance.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Problem with connecting Freeform shapes

    Hi Joe,

    Welcome to the Forum!

    There is no attachment
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    05-23-2016
    Location
    India
    MS-Off Ver
    Office 16
    Posts
    2

    Re: Problem with connecting Freeform shapes

    VBA Freeform.PNG

    Sorry, my bad. Please refer to the attached image.

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem connecting to Oracle with VBA
    By Sleipner9 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2014, 12:19 PM
  2. Essbase Add-In: Problem connecting to server
    By LRG5151 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-15-2013, 04:32 PM
  3. Problem Connecting to Database
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-15-2011, 10:07 AM
  4. [SOLVED] Creating shapes dynamically and connecting them
    By jo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2006, 11:10 AM
  5. [SOLVED] Problem connecting to Analysis Services
    By ln54 in forum Excel General
    Replies: 1
    Last Post: 03-08-2006, 01:10 PM
  6. Freeform shapes
    By Jackie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2005, 01:05 PM
  7. [SOLVED] problem in connecting to winsql
    By reenu tuteja via OfficeKB.com in forum Excel General
    Replies: 0
    Last Post: 03-22-2005, 03:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1