Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Word document with VBA and Form Fields reset when select File,Print
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-26-2018, 09:18 PM
gmayor's Avatar
gmayor gmayor is offline Word document with VBA and Form Fields reset when select File,Print Windows 10 Word document with VBA and Form Fields reset when select File,Print Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,144
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
There are no macros in your document. What you posted was a field calculation.

I never did like FillIn fields. The attached version uses a content control date picker to get the end date (which presumably will always be a Friday) and then populates the table based on that selection, using a macro.

If you want the end date to be any day of the week, remove the line
Code:
EndDate = EndDate - Weekday(EndDate) + 6
from the macro.
Attached Files
File Type: docm sample fields-1.docm (29.8 KB, 17 views)
__________________
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
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't reset form fields (Word 2013) and conditional formatting rogelinepaula Word VBA 24 01-07-2016 03:54 PM
Extract form fields to Word Document RonNCmale Word VBA 22 01-11-2014 05:06 AM
Word document with VBA and Form Fields reset when select File,Print Recovering a word file (Select the encoding that makes your document readable) Canni Word 2 08-29-2012 02:46 PM
Word document with VBA and Form Fields reset when select File,Print Preventing Form Fields to Reset PosseJohn Word VBA 4 07-15-2011 09:44 PM
Word document with VBA and Form Fields reset when select File,Print Word Macro That Checks a Check Box Form Field When File Print is Executed DKerne Word VBA 4 06-09-2011 11:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:03 AM.

Contact Us - Privacy Statement - Top

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