+ Reply to Thread
Results 1 to 4 of 4

Use cell input to move shape horizontally

  1. #1
    Registered User
    Join Date
    09-27-2010
    Location
    England
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    20

    Question Use cell input to move shape horizontally

    I would like to have a shape object, a "double arrow" (Arrow Style 7) which I will place in a horizontal direction on my worksheet parallel to a defined axis.

    I would like to configure the following dimensions of the double arrow by cell input:
    1. length of double arrow (e.g. in pixels)
    2. horizontal position along axis (e.g. in pixels)

    Example: The horizontal axis represents 0 - 720 degrees (720 pixels either represented by one cell width or a number or cells in a row)
    1. length of double arrow is 100 degrees (100 pixels)
    2. horizontal position is offset 600 degrees (600 pixels) from axis start position at 0 degress i.e. double arrow of length 100 degrees would occupy 600 - 700 degree position

    I intend to add a number of such horizontal double arrows at different positions parallel to each other...( a separate row for each maybe)

    But first... any ideas on how this can be done... ideally directy on the worksheet (not by chart)
    Let me know if you have any questions.

    I don't know if there is a simple way to do this without VBA but wouldn't know how at the moment... I think it can definately be achieved with VBA just don't know how
    Last edited by nuttyengineer; 02-16-2011 at 09:36 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,524

    Re: Use cell input to move shape horizontally

    This is a little confusing as there is only 360 degrees in a circle. Could you supply a sample workbook as to what you are trying to achieve?

  3. #3
    Registered User
    Join Date
    09-27-2010
    Location
    England
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    20

    Re: Use cell input to move shape horizontally

    Hello Dave,

    Thanks for your reply. Sorry for my confusing post but hopefully when you see the attached example of what I would like to achieve it will make more sense.

    Please see the examples in the attached file for a diagramatic explanation of what I would like to do:
    - Example A is the same as outlined in my original post
    - Example E is a special case but ultimately what I would like to finally achieve with this work.

    Thanks again for any help offered.

    Nutty
    Attached Files Attached Files
    Last edited by nuttyengineer; 02-18-2011 at 07:30 PM.

  4. #4
    Registered User
    Join Date
    09-27-2010
    Location
    England
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    20

    Re: Use cell input to move shape horizontally

    Any help with this one anyone?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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