Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-31-2015, 10:49 PM
gmayor's Avatar
gmayor gmayor is offline prevent repetition in form Windows 7 64bit prevent repetition in form Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The best way to do this is to create a simple userform http://www.gmayor.com/Userform.htm which collects the variable data and inserts it into the required places in the document using bookmarked locations. You will find a handy function for filling bookmarks with values from the userform at http://www.gmayor.com/word_vba_examples.htm

Variable data can be read from a data source (or sources), ideally Excel worksheet(s), or it can be typed into a text field. The examples in the first link used typed data. For more on filling list boxes from external data see http://www.gmayor.com/Userform_ComboBox.html
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
prevent repetition in form Prevent deleting lists Phil65 OneNote 1 03-19-2015 03:24 PM
prevent repetition in form Prevent Copying and Pasting Jimmy Tsawo Excel 3 02-20-2014 03:54 AM
prevent repetition in form How can I PREVENT headings I don't want? peytontodd Word 3 11-23-2013 05:08 PM
how can prevent a user from seeing an email anguiahm Outlook 0 05-17-2013 10:37 AM
text box, prevent from printing Tanya Word 0 02-05-2010 06:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:44 AM.


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