View Single Post
  #1   Report Post  
Posted to microsoft.public.word.tables
Penny Miller Penny Miller is offline
external usenet poster
 
Posts: 2
Default Formula for non blank cell

I hope this makes sense... I'm working with a department that uses word to
keep track of when employees are doing their designated duties by system
date/time to make sure they aren't fudging the time.

I've created a document that has two different tables in it and the first
table (7 columns) can be un protected with no worries. However, the second
table (2 columns) needs to have cell A1 protected and if a user keys in any
text in B1 I need it to add the current date/time to A1 once they hit the
enter/tab key.

If B1 isnot blank then A1=CREATEDATE \@ "yyyy-MM-dd" \@ "HH:mm:ss"

Thanks