Current Date problem

Darren, welcome to the board though please note we have a few Q&A forums and ask you post in the most appropriate to your question.

I've moved your thread from Outlook to Excel Programming Forum where you should get a suitable response.

(you could do this with formulae [iteration] but I wouldn't advise it)

Originally Posted by cafc_fuller

Hello,

However if i open the file tomorrow the file has changed date to its current date.

This is unclear (at least to me), don't you want the date to refresh with each new day?

Depending on your workbook structure, you would need to add either another row or column for the new date. Mayhap if you could upload a mock workbook so that we could see the structure, and then create the code accordingly.

I've looked at your form and have at least 1 area of concern. If we write code to insert today's date, it will always insert the current date into that cell. I think we could modify the code to keep the original date but we would have to base the modification of something unique, the order number perhaps. What do you think? Basically, you want the current date to be entered only if there is a new order, correct?

You could try this:

Please Login or Register  to view this content.