Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 07-29-2017, 10:39 AM
corriganc corriganc is offline Want to use the DateAdd function to type text at a location in word document, using date from CC Windows 10 Want to use the DateAdd function to type text at a location in word document, using date from CC Office 2016
Novice
Want to use the DateAdd function to type text at a location in word document, using date from CC
 
Join Date: Jul 2017
Location: United Kingdom
Posts: 6
corriganc is on a distinguished road
Smile

Quote:
Originally Posted by gmayor View Post
Just delete the paragraph that you have scribbled out. The other field already has the required name and that will be used by the macro.
I've just tested out your most recent suggestion, and it worked!
There is only one issue with the document - since the user is more likely to enter the "LastExamination" text after they have entered the "Frequency" text how would I go about modifying the code to calculate the date after the "LastExamination" field is entered, rather than after the "Frequency" field. An even better solution would be to have it calculate/modify the "NextExamination" date after the "Freqency" or the "LastExamination" field is entered. Basically, that would mean that the "NextExamination" field would be populated correctly regardless of which order the user fills in the document; because at the moment, if the "Frequency" field is filled in before the "LastExamination" field (which is now at the bottom) the document displays a VBA error [Type Mismatch] - I can forsee this being an issue since trying to explain to the users that they need to fill in the bottom before the top will blow their minds!

Any help that you could provide would be greatly appreciated; I did try to work it out myself, but the code is far too complex for me - my status on this site describes me perfectly - "Novice"!

Kind Regards,
Callum
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to use the DateAdd function to type text at a location in word document, using date from CC How to have the location (path) of the Word document on the title bar? Jamal NUMAN Word 24 09-06-2017 12:18 PM
Returning text, date, time, location from one Excel sheet to another dave57 Excel 17 06-15-2017 10:45 AM
Want to use the DateAdd function to type text at a location in word document, using date from CC Word type document auto fill in Sircooks Excel 5 05-14-2016 05:01 AM
Want to use the DateAdd function to type text at a location in word document, using date from CC Why do pages 10-24 disappear when I type in more text on page 2 or paste new text into the document? RET Word 1 05-02-2016 07:28 PM
Date Function in word? aligahk06 Word 1 04-21-2010 06:33 AM

Other Forums: Access Forums

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


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