CROSS REFERENCE
in [Word VBA]
|
From: JJ on 3 Jun 2010 06:08 Forgive me for posting this again but I still haven't found a satisfactory solution. Please see if anyone can assist me. I know that you can use word to insert reference, cross reference but that is not exactly what I want. What I need is something that will refer to the sub clause number where the reference is but include the main clause text e.g. Word 2003. I have a document which points to various paragraphs and I would like to usecrossreferencing as well as the name of the main paragraph when I refer to it e.g. SALE OF SHARES AGREEMENT 1 INTERPRETATION 1.1 xxxxxxx 1.2 xxxxxxx 2 PARTIES 2.1 The parties to this agreement are: 2.1.1 xxxx 2.1.2 xxxx In clause 2.1.2 you want to refer to clause 2.1.1 but insert the main heading PARTIES so the clause will look as follows: 2.1.2. xxxxx as referred to in clause 2.1.1 [PARTIES]. (meaning the number of the sub clause togther with the heading (text) of the main clause not the sub clause text). The reason that I need a macro is that this should happen automatically so if they click cross reference, it will allow them to select the relevant sub clause then the macro should insert the sub clause number together with the main clause heading. Thank you to everyone attempting to help me. I am desperate.
From: Doug Robbins - Word MVP on 3 Jun 2010 19:50 The way I am thinking that it might be possible to do this is to use a userform that contains a series of comboboxes or listboxes each of which is populated with a cascading arrangement of the different headings in the document and then display that userform when the user wants to insert such a cross reference and they would make their selected combination of the available items and then a reference thereto would be inserted into the document. You would need to be doing it a lot to make the development of the utility worth while. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "JJ" <joey(a)ultimatefunctions.co.za> wrote in message news:734afdb2-3c73-4bf0-b0e5-68e4fea50b14(a)w3g2000vbd.googlegroups.com... > Forgive me for posting this again but I still haven't found a > satisfactory solution. Please see if anyone can assist me. I know that > you can use word to insert reference, cross reference but that is not > exactly what I want. What I need is something that will refer to the > sub clause number where the reference is but include the main clause > text > > e.g. > Word 2003. I have a document which points to various paragraphs and I > would like to usecrossreferencing as well as the name of the main > paragraph when I refer to it e.g. > SALE OF SHARES AGREEMENT > 1 INTERPRETATION > 1.1 xxxxxxx > 1.2 xxxxxxx > 2 PARTIES > 2.1 The parties to this agreement are: > 2.1.1 xxxx > 2.1.2 xxxx > > In clause 2.1.2 you want to refer to clause 2.1.1 but insert the main > heading PARTIES so the clause will look as follows: > > 2.1.2. xxxxx as referred to in clause 2.1.1 [PARTIES]. (meaning the > number of the sub clause togther with the heading (text) of the main > clause not the sub clause text). > The reason that I need a macro is that this should happen > automatically so if they click cross reference, it will allow them to > select the relevant sub clause then the macro should insert the sub > clause number together with the main clause heading. > > Thank you to everyone attempting to help me. I am desperate.
From: macropod on 4 Jun 2010 05:18 Hi JJ, You haven't indicated why the solution I suggested isn't suitable. It's certainly simple and effective. All it requires is taking the time to learn how to use Word, rather than taking a brute-force approach to the problem. -- Cheers macropod [Microsoft MVP - Word] "JJ" <joey(a)ultimatefunctions.co.za> wrote in message news:734afdb2-3c73-4bf0-b0e5-68e4fea50b14(a)w3g2000vbd.googlegroups.com... > Forgive me for posting this again but I still haven't found a > satisfactory solution. Please see if anyone can assist me. I know that > you can use word to insert reference, cross reference but that is not > exactly what I want. What I need is something that will refer to the > sub clause number where the reference is but include the main clause > text > > e.g. > Word 2003. I have a document which points to various paragraphs and I > would like to usecrossreferencing as well as the name of the main > paragraph when I refer to it e.g. > SALE OF SHARES AGREEMENT > 1 INTERPRETATION > 1.1 xxxxxxx > 1.2 xxxxxxx > 2 PARTIES > 2.1 The parties to this agreement are: > 2.1.1 xxxx > 2.1.2 xxxx > > In clause 2.1.2 you want to refer to clause 2.1.1 but insert the main > heading PARTIES so the clause will look as follows: > > 2.1.2. xxxxx as referred to in clause 2.1.1 [PARTIES]. (meaning the > number of the sub clause togther with the heading (text) of the main > clause not the sub clause text). > The reason that I need a macro is that this should happen > automatically so if they click cross reference, it will allow them to > select the relevant sub clause then the macro should insert the sub > clause number together with the main clause heading. > > Thank you to everyone attempting to help me. I am desperate.
From: JJ on 4 Jun 2010 06:13 On Jun 4, 11:18 am, "macropod" <macro...(a)invalid.invalid> wrote: > Hi JJ, > > You haven't indicated why the solution I suggested isn't suitable. It's certainly simple and effective. All it requires is taking > the time to learn how to use Word, rather than taking a brute-force approach to the problem. > > -- > Cheers > macropod > [Microsoft MVP - Word] > > > > "JJ" <j...(a)ultimatefunctions.co.za> wrote in messagenews:734afdb2-3c73-4bf0-b0e5-68e4fea50b14(a)w3g2000vbd.googlegroups.com... > > Forgive me for posting this again but I still haven't found a > > satisfactory solution. Please see if anyone can assist me. I know that > > you can use word to insert reference, cross reference but that is not > > exactly what I want. What I need is something that will refer to the > > sub clause number where the reference is but include the main clause > > text > > > e.g. > > Word 2003. I have a document which points to various paragraphs and I > > would like to usecrossreferencing as well as the name of the main > > paragraph when I refer to it e.g. > > SALE OF SHARES AGREEMENT > > 1 INTERPRETATION > > 1.1 xxxxxxx > > 1.2 xxxxxxx > > 2 PARTIES > > 2.1 The parties to this agreement are: > > 2.1.1 xxxx > > 2.1.2 xxxx > > > In clause 2.1.2 you want to refer to clause 2.1.1 but insert the main > > heading PARTIES so the clause will look as follows: > > > 2.1.2. xxxxx as referred to in clause 2.1.1 [PARTIES]. (meaning the > > number of the sub clause togther with the heading (text) of the main > > clause not the sub clause text). > > The reason that I need a macro is that this should happen > > automatically so if they click cross reference, it will allow them to > > select the relevant sub clause then the macro should insert the sub > > clause number together with the main clause heading. > > > Thank you to everyone attempting to help me. I am desperate.- Hide quoted text - > > - Show quoted text - I am not sure that I understand you correctly. I know how to use cross references (well at least I think I know) but because I want to use the heading of the main paragraph together with the number of a sub paragraph when cross reference, I have no idea how to do it. If you say use heading text as the cross reference it inserts the text of the sub paragraph and not the main paragraph. Perhaps I am misunderstanding.
From: Doug Robbins - Word MVP on 4 Jun 2010 08:04
To do what you want using Word out-of-the-box, you will need to insert two cross references, one to the number of the level 3 heading and one to the text of the heading 1. Not a particularly difficult task. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "JJ" <joey(a)ultimatefunctions.co.za> wrote in message news:29472357-07f3-4077-9d42-a096a8c2e33e(a)u26g2000yqu.googlegroups.com... > On Jun 4, 11:18 am, "macropod" <macro...(a)invalid.invalid> wrote: >> Hi JJ, >> >> You haven't indicated why the solution I suggested isn't suitable. It's >> certainly simple and effective. All it requires is taking >> the time to learn how to use Word, rather than taking a brute-force >> approach to the problem. >> >> -- >> Cheers >> macropod >> [Microsoft MVP - Word] >> >> >> >> "JJ" <j...(a)ultimatefunctions.co.za> wrote in >> messagenews:734afdb2-3c73-4bf0-b0e5-68e4fea50b14(a)w3g2000vbd.googlegroups.com... >> > Forgive me for posting this again but I still haven't found a >> > satisfactory solution. Please see if anyone can assist me. I know that >> > you can use word to insert reference, cross reference but that is not >> > exactly what I want. What I need is something that will refer to the >> > sub clause number where the reference is but include the main clause >> > text >> >> > e.g. >> > Word 2003. I have a document which points to various paragraphs and I >> > would like to usecrossreferencing as well as the name of the main >> > paragraph when I refer to it e.g. >> > SALE OF SHARES AGREEMENT >> > 1 INTERPRETATION >> > 1.1 xxxxxxx >> > 1.2 xxxxxxx >> > 2 PARTIES >> > 2.1 The parties to this agreement are: >> > 2.1.1 xxxx >> > 2.1.2 xxxx >> >> > In clause 2.1.2 you want to refer to clause 2.1.1 but insert the main >> > heading PARTIES so the clause will look as follows: >> >> > 2.1.2. xxxxx as referred to in clause 2.1.1 [PARTIES]. (meaning the >> > number of the sub clause togther with the heading (text) of the main >> > clause not the sub clause text). >> > The reason that I need a macro is that this should happen >> > automatically so if they click cross reference, it will allow them to >> > select the relevant sub clause then the macro should insert the sub >> > clause number together with the main clause heading. >> >> > Thank you to everyone attempting to help me. I am desperate.- Hide >> > quoted text - >> >> - Show quoted text - > > I am not sure that I understand you correctly. I know how to use cross > references (well at least I think I know) but because I want to use > the heading of the main paragraph together with the number of a sub > paragraph when cross reference, I have no idea how to do it. If you > say use heading text as the cross reference it inserts the text of the > sub paragraph and not the main paragraph. Perhaps I am > misunderstanding. |