Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2014, 05:32 AM
adisl adisl is offline Word macro: set automatic date in a table cell Windows 7 64bit Word macro: set automatic date in a table cell Office 2007
Novice
Word macro: set automatic date in a table cell
 
Join Date: Mar 2014
Posts: 7
adisl is on a distinguished road
Default Word macro: set automatic date in a table cell

Is it possible to create a macro that inserts a date before the text, each time you write something new in a table cell, after you have saved?. For example in column 3.



column 1 | column 2 | 21.04.2014 text, text, text, text.
Reply With Quote
  #2  
Old 03-27-2014, 05:12 PM
macropod's Avatar
macropod macropod is offline Word macro: set automatic date in a table cell Windows 7 32bit Word macro: set automatic date in a table cell Office 2010 32bit
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

Not unless you're using 'Track Changes' and, even then, updating a cell after you've saved seems pretty pointless, since the update won't have been saved, meaning you'll have to save again to retain it and that will trigger a new round of updating the cell and saving, ad infinitum...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-28-2014, 03:08 AM
adisl adisl is offline Word macro: set automatic date in a table cell Windows 7 64bit Word macro: set automatic date in a table cell Office 2007
Novice
Word macro: set automatic date in a table cell
 
Join Date: Mar 2014
Posts: 7
adisl is on a distinguished road
Default

The idea is that there will always be a date before each new event that is written in the same cell. It could of course be written manually, but when there are several different people using the same document, it is often forgotten</SPAN>
Reply With Quote
  #4  
Old 03-28-2014, 11:37 AM
fumei fumei is offline Word macro: set automatic date in a table cell Windows 7 64bit Word macro: set automatic date in a table cell Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

Quote:
before each new event that is written in the same cell.

I think we understand what you want, but it remains a fact that typing something into the cell is not a useable (triggerable) event.
Reply With Quote
  #5  
Old 03-31-2014, 01:31 AM
adisl adisl is offline Word macro: set automatic date in a table cell Windows 7 64bit Word macro: set automatic date in a table cell Office 2007
Novice
Word macro: set automatic date in a table cell
 
Join Date: Mar 2014
Posts: 7
adisl is on a distinguished road
Default

Ok thanks for reply
Reply With Quote
  #6  
Old 03-31-2014, 07:51 AM
fumei fumei is offline Word macro: set automatic date in a table cell Windows 7 64bit Word macro: set automatic date in a table cell Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

What you could do is have a small macro that you fire with, say, a keyboard shortcut. It could insert your date. So type your text and then your shortcut.

Code:
Dim r As Range
Set r = Selection.Range.Cells(1).Range
r.Collapse 1
r.Fields.Add r, Type:=wdFieldDate
Reply With Quote
  #7  
Old 03-31-2014, 11:30 PM
adisl adisl is offline Word macro: set automatic date in a table cell Windows 7 64bit Word macro: set automatic date in a table cell Office 2007
Novice
Word macro: set automatic date in a table cell
 
Join Date: Mar 2014
Posts: 7
adisl is on a distinguished road
Default

This was a good idea that will work
Thanks a lot
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Make table cell active add date count date MelHerndon Word VBA 3 01-21-2013 04:23 PM
Word macro: set automatic date in a table cell Inserting a date calculated from a table cell theMikeD Word 2 09-11-2012 05:46 PM
Word macro: set automatic date in a table cell Automatic date updates. WLVanS Word 12 01-29-2011 04:01 AM
How can I make a cell color RED under the Today's date cell? Learner7 Excel 2 07-08-2010 12:52 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:06 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