In one of my macro's,I have the following code:
Range("D4").Value = FormatDate, "dd.mm.yyyy")
Rows(4).AutoFit
That means that automaticly the date of the current day is insert.
Is there a possibility that this macro give an input-box to insert a date,because information on the sheet from a week ago gives by opening this sheet autmaticly the current date.
Many thanks for help.
Range("D4").Value = FormatDate, "dd.mm.yyyy")
Rows(4).AutoFit
That means that automaticly the date of the current day is insert.
Is there a possibility that this macro give an input-box to insert a date,because information on the sheet from a week ago gives by opening this sheet autmaticly the current date.
Many thanks for help.