¨ FrontPage ¨ Outlook ¨
¨ Miscellaneous ¨
So you want to have a form field that is completed by the user, and then have this information populated in various other locations throughout the document, so the user doesn’t have to retype it. This could be ideal for, for instance, a contract where the contractor’s name is filled in throughout the legalese.
This article will help you do that within a protected form.
If you only need to insert a cross reference to a heading or other field in Word, begin at Step 3.
If you only need to insert a cross reference to some text, first select the text, and hit InsertàBookmark and give it a name (no spaces!). Then begin with Step 3.
From the Forms toolbar, insert a text form field by hitting the ab| button and the form field drops into the document at the insertion point, as shown:
Double-click the form field to bring up the Text Form Field Options window. Tick the Calculate on Exit checkbox.
This causes an event to fire when the form field is exited, which causes the cross-referenced fields to be updated.
Click in the bookmark name area, and give the bookmark a meaningful name. Our sample used “Contractor”; see below.
From the menu, choose InsertàReferenceàCross Reference.
From the Reference type drop-down, choose Bookmark. Select the name of the bookmark you created. Hit Insert. The Cancel button changes to Close. Hit Close to close the cross-reference dialog.
To test your cross reference, first protect your document. Then type something into the form field you first created and hit tab to exit the form field.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved