View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdaws pdaws is offline
external usenet poster
 
Posts: 20
Default Inserting current date

Hi,

When cell b25 is populated by a macro, I would like for cell d25 to
automatically enter the current date based on the population of cell b25. I
would also like for that date to remain constant and not change when someone
opens the form. Is it possible to create a macro to perform this function or
is there a formula that I can put in cell d25?

Thanks for your help.