Thread: Insert date & time when 5 condition are true
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jenn jenn is offline
external usenet poster
  
Posts: 107
Default Insert date & time when 5 condition are true
I am trying to create VB code in order for the following to occur:

Cells E3:I3 must all equal "Completed" (dropdown selection using Data
Validation) in order for cell L3 to insert a date and time stamp. Once the
date & time are inserted they MUST remain constant, they cannot change with
recalculations and reopening the spreadsheet.

Any ideas?
--
Jenn
Reply With QuoteReply With Quote