Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-31-2021, 03:11 AM
wclark160 wclark160 is offline How to Update "Days since activity" using spin button in word Windows XP How to Update "Days since activity" using spin button in word Office 2016
Novice
How to Update "Days since activity" using spin button in word
 
Join Date: Jan 2021
Posts: 1
wclark160 is on a distinguished road
Default How to Update "Days since activity" using spin button in word


Hello everyone. I have reached the end of the internet I feel looking for the answer to this and am now coming to the experts. I have a question regarding auto updating numbers in a word file. I work at a location that requires a daily email that essentially updates the Executives on days since last activity. Examples are worth 1000 words so I have included one! Essentially, everyday I open this file, and provided nothing has happened, adjust the days to add 1 , click save and send the data to the execs. Is there a way to just use a spin button or something to Up the days by one automatically? As simple as it is to just up the days manually, I use these exercises to get better at Word everyday. Note: The formatting must stay exactly the same.
Attached Files
File Type: docx Example.docx (50.1 KB, 8 views)
Reply With Quote
  #2  
Old 01-31-2021, 03:43 AM
macropod's Avatar
macropod macropod is offline How to Update "Days since activity" using spin button in word Windows 10 How to Update "Days since activity" using spin button in word Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you recorded the date of the last event, a field code could be used to calculate the days elapsed. See Calculate the # Days Difference Between Two Dates, on page 11 of my Microsoft Word Date Calculation Tutorial, in a 'Sticky' thread at the top of the Word forum:
https://www.msofficeforums.com/word/...-tutorial.html
Do read the tutorial's introductory material.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-31-2021, 03:40 PM
Charles Kenyon Charles Kenyon is online now How to Update "Days since activity" using spin button in word Windows 10 How to Update "Days since activity" using spin button in word Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I likewise recommend you use a field from Paul's tutorial. While he told you to be sure to read the introductory material, that cannot be stressed enough.

You will then have a field. Like many fields, it will not automatically update when the document is opened. It would be enough to use Ctrl+A followed by F9. If that is inconvenient, you could use a macro to update just that field when the document is opened.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
I clicked "this document" in VBA thinking it was a menu button, it said "saving", how can I reverse messgchr Word VBA 2 07-20-2020 06:52 PM
How to Update "Days since activity" using spin button in word Word 2019 began "Not Responding" a days ago when I try to save KDuncan Word 4 03-10-2019 11:16 PM
How to create a "Font color" button and a "Highlight text" button in the Quick Launch toolbar ? gloub Word 12 02-19-2019 03:19 PM
How to use a "Save As" button without causing digital signatures to become "Invalid"? jferg Word VBA 0 02-16-2016 03:04 PM
How to Update "Days since activity" using spin button in word How do I get auto-updated "number of days since specified date" on MS word? terry795 Word 16 01-07-2016 04:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:53 PM.


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