+ Reply to Thread
Results 1 to 5 of 5

Line to move based on a value????

  1. #1
    Registered User
    Join Date
    10-16-2017
    Location
    Melbourne, Australia
    MS-Off Ver
    2016
    Posts
    5

    Line to move based on a value????

    I have a rectangle that is x in length. And I want to draw I line at x/2 or x/3 (link the ratio to a cell). Is this possible????

    Cheerio!

    All help greatly appriciated
    Last edited by mrsuperunreal; 10-16-2017 at 02:58 PM.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,651

    Re: Line to move based on a value????

    Try this for "Rectangle 1"
    Place the denominator 2,3 or 4 etc. in "A1"
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-16-2017
    Location
    Melbourne, Australia
    MS-Off Ver
    2016
    Posts
    5

    Re: Line to move based on a value????

    Ohh that works very nice. I'll play around with it but it should do the job. My alternative was to setup a chart and move it to the back, but this is much more elegant. Thanks a million. Just for interest its for working with labels. And determining the space you can give to the front or the back.

    May I ask one more thing, would there be a code for a button to clear the line? - I apologies this is not the exact forum but certainly follows the thread.

    Thanks again!!!!

  4. #4
    Registered User
    Join Date
    10-16-2017
    Location
    Melbourne, Australia
    MS-Off Ver
    2016
    Posts
    5

    Re: Line to move based on a value????

    I just realized that my last request my not be so easy as each time you draw a line it gets a new name. So no problem if its not going to work using a button. Maybe just good old select and delete is what should happen. Anyway love to hear your thoughts. Thanks.

  5. #5
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,651

    Re: Line to move based on a value????

    Something like this seems to work:-
    Please Login or Register  to view this content.

+ 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