I will try to expose my question as simple as possible:
I have a startup userform with a field named "Date", in which the users are required to enter the current date every time the file is opened.
What I want is Excel to 'cumulate' the date entries in that field ("Date"), in a sheet named "DateField_History", starting from cell B3 and down.
I'll clarify.
In the "Date" field (Userform):
- On 5th of May I wrote: "05/05/2010" (once)
- On 7th of May I wrote: "07/05/2010" (once)
- Yesterday I wrote: "08/05/2010" (twice, because I needed to use the file twice)
So all these date entries (all of them) must appear as a list, in sheet "DateField_History", starting in cell B3.
It's something like 'number of visits' to the file or 'date entry history'.
N.B.: every time the list is completely deleted, new entries should always start from cell B3 (row 3 becomes the first empty row of that particular range, if we fully delete the list).
Here's a picture

Uploaded with ImageShack.us
I have a startup userform with a field named "Date", in which the users are required to enter the current date every time the file is opened.
What I want is Excel to 'cumulate' the date entries in that field ("Date"), in a sheet named "DateField_History", starting from cell B3 and down.
I'll clarify.
In the "Date" field (Userform):
- On 5th of May I wrote: "05/05/2010" (once)
- On 7th of May I wrote: "07/05/2010" (once)
- Yesterday I wrote: "08/05/2010" (twice, because I needed to use the file twice)
So all these date entries (all of them) must appear as a list, in sheet "DateField_History", starting in cell B3.
It's something like 'number of visits' to the file or 'date entry history'.
N.B.: every time the list is completely deleted, new entries should always start from cell B3 (row 3 becomes the first empty row of that particular range, if we fully delete the list).
Here's a picture

Uploaded with ImageShack.us