Userform date

[capneddie]

Userform: I want to automatically add in the date that the entry was made into the userform. When user clicks enter, the information moves to a spreadsheet. I want an automatic date to appear in a column in the spreadsheet to track the entry.

[royUK]

Adjust this to suit

Cells(1,1).Value=Date

[scaffdog845]

An interesting use of "Timestamping" can be found here http://chandoo.org/wp/2009/01/08/tim...-formula-help/

[solnajeff]

Hi

A couple of lines of code like

Let Cells(1, 1).Value = Now
Let Cells(1, 1).NumberFormat = "mm/dd/yy"

The first line inserts the current date and the second formats the appearance.

Regards

Jeff