Adding a fixed date after clicking a VBA button

[RJSIGKITS]

Hey guys.

I have a sheet which is a new customer data sheet for capturing new client leads.
It has a button control (named 'Save Client') to save the document which has all sorts of VBA code attached to it to create directories etc for the new client, and I need the sheet to record the date that it was created.

Is there a way to add a fixed date 'Stamp' to a cell once the button is clicked?

Importantly, I need the date to be fixed and not update each time the document is opened, so 'TODAY() and NOW() won't do it, I don't think..

 

[Fluff]

Try
Range("A1").Value=Date

 

[RJSIGKITS]

Try
Range("A1").Value=Date

Ha!
That seems to do it! As Simple as that!..