Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2016, 12:42 AM
Maestrie Maestrie is offline Add a line connecting to identical numbers Windows 10 Add a line connecting to identical numbers Office 2016
Novice
Add a line connecting to identical numbers
 
Join Date: Jun 2016
Posts: 4
Maestrie is on a distinguished road
Default Add a line connecting to identical numbers

Hello everyone!

I'm making models of word documents for my association, and i'm looking for a way that lines appear automatically when a number is present à two points.


it's not necesseraly a completely horizontal line, it may be a bit leaning.
here is a picture of what I would like to do:



The column on the left doesn't move, the numbers are allways in that order.
the column on the right will have the numbers changing, so I was planning to make a field with a list of numbers to choose, and when that choice is done, the line should appear automatically betwenthe two identical numbers.

the problem is that I don't know if its possible and if it is, how to do it.

thanks for the help

Maestrie

Edit: My Office version is 2016, but the file has to work at least with 2013 version

Last edited by Maestrie; 06-29-2016 at 12:58 AM. Reason: adding office version
Reply With Quote
  #2  
Old 06-29-2016, 11:43 PM
Maestrie Maestrie is offline Add a line connecting to identical numbers Windows 10 Add a line connecting to identical numbers Office 2016
Novice
Add a line connecting to identical numbers
 
Join Date: Jun 2016
Posts: 4
Maestrie is on a distinguished road
Default

Hello,
Any ideas?

I noticed there was the bookmark and maybe if we could make a condition, like if the number is the same in those two bookmarks, then put a line connecting them

If someone has an idea, I would be very thankfull, because i'm running out of myself.

thanks for the help again.
Reply With Quote
  #3  
Old 06-30-2016, 12:43 AM
Guessed's Avatar
Guessed Guessed is offline Add a line connecting to identical numbers Windows 10 Add a line connecting to identical numbers Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I would draw all the lines you want and then label them so they can be individually treated. Then you can flip their 'visibility' property with your code. This is far easier as you don't need to fiddle with their endpoint locations and colours/width/pattern etc in your code.

An example showing how easy it is to toggle visibility on a couple of lines is below
Code:
Sub HideALine()
  With ActiveDocument
    .Shapes(1).Visible = Not .Shapes(1).Visible
    .Shapes(2).Visible = Not .Shapes(2).Visible
  End With
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #4  
Old 06-30-2016, 11:14 PM
Maestrie Maestrie is offline Add a line connecting to identical numbers Windows 10 Add a line connecting to identical numbers Office 2016
Novice
Add a line connecting to identical numbers
 
Join Date: Jun 2016
Posts: 4
Maestrie is on a distinguished road
Default

Hello Guessed,

Firts of all, thanks for replying.

May I Ask how you do that?
I don't even Know how to use macros, so I don't know where to put that text.

And I precise that the lines may be randomly set, it isn't every time the same configuration.

So if I understand well, you are telling me to make a hundred lines for every possibility and hide them after? That does'nt bothers me, but pleace just tell me how to do It.
And by the way, how can i Make a condition so that if it is, for example the line 9 in my picture, that changes the transparency of the line?

sorry, I may ask a bit too much, I don't know what time it represents to do that.
maybe if you juste made me an example for one line, I could do the others if it's more simple to you.

Anyway, thank you for replying.

Maestrie
Reply With Quote
  #5  
Old 07-01-2016, 12:18 AM
Guessed's Avatar
Guessed Guessed is offline Add a line connecting to identical numbers Windows 10 Add a line connecting to identical numbers Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

This task requires extensive vba coding to do in Word. If you don't know how to write code then it is WAY TOO DIFFICULT for you to attempt.

Nothing like this can happen 'automatically' without the computer being told via VBA:
1. What to put on the left hand column and in what order (presumably randomised in some way)
2. What to put on the right hand column and in what order (presumably also randomised)
3. How to relate elements on the left to elements on the right
4. What the lines should look like in terms of colour/thickness/positioning
5. How to reveal the lines one at a time in response to some user-initiated triggers.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #6  
Old 07-01-2016, 04:19 AM
Maestrie Maestrie is offline Add a line connecting to identical numbers Windows 10 Add a line connecting to identical numbers Office 2016
Novice
Add a line connecting to identical numbers
 
Join Date: Jun 2016
Posts: 4
Maestrie is on a distinguished road
Default

i'm Indeed not into writing code.

I guess i'll have to make it manually.

Thanks anyway for answering me.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a line connecting to identical numbers Getting the line numbers in the footer to line up...? dwarsement Word 3 07-01-2015 01:17 AM
Add a line connecting to identical numbers get rid of line above page numbers at bottom of pages. Joanrichmond Word 1 02-11-2014 12:57 PM
Add a line connecting to identical numbers Connecting text to numbers microsoftnovice Excel 2 10-31-2012 10:43 AM
Add a line connecting to identical numbers Add line numbers to end of each line deboo Word 6 08-20-2012 07:35 PM
Add a line connecting to identical numbers How to paste into another app without line numbers? Moonf4 Word 1 04-18-2011 03:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft