View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smonczka smonczka is offline
external usenet poster
 
Posts: 29
Default Date Function needed

I'm running into a problem with putting a date in a form i'm making.
I want to have todays date populate a cell when the form is opened.
But only once. So if a person opens the form for the first time it
populates todays date... today(). But if they open the form up again
that date will not change. If you use =today() then each time you
open the form up it populates that cell with today’s date.

Any idea's how i can code a cell with today’s date upon creation but
not have it change each time the form is opened.

Thanks for the help,
Steve