How to 'cumulate' Userform entries in a Sheet

[Luisao82]

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

 

[Smitty]

Welcome to the Board!

Why force your users to do something that you can do automatically:

<font face=Calibri><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Workbook_Open()<br>    Sheets("DateField_History").Cells(Rows.Count, "B").End(xlUp).Offset(1).Value = <SPAN style="color:#00007F">Date</SPAN><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

Hope that helps,