Question about dates

[Urlord]

Is it possible to have a date entered automatically entered on a form created in Excel but prevent that date from changing the next day.
I have a spreadsheet to trace customer complaints and I would like the date to be automatically entered when the info is recorded but not change after the form is complete.

Thanks

 

[VoG]

Yes it is possible using event code. In which range is the info entered and where should the date go?

 

[desdd57]

I have the same question, but would like to also relate that to time.

Des

 

[VoG]

I have the same question, but would like to also relate that to time.

Des

OK, well same questions to you

 

[Urlord]

Yes it is possible using event code. In which range is the info entered and where should the date go?

Not quite sure what you are asking but I will explain a much as I can
I have created a form ( Form 1 ) with cells that automatically updates cells in sheet 1. I would like a blank form to automaically have today's date entered into cell j5 ( I know you can use today() to accomplish this ) I would like lock this date into j5 once other fields have been filled out.

Hope this helps

 

[VoG]

Do you mean a userform? If so what is the code used to populate Sheet1?

 

[Urlord]

do you mean a userform? If so what is the code used to populate sheet1?

='001-cs'!j5

 

[VoG]

So it isn't a userform.

Which is the final cell that you complete on your 'form' and which cell in Sheet1 should contain the date?

 

[Urlord]

So it isn't a userform.

Which is the final cell that you complete on your 'form' and which cell in Sheet1 should contain the date?

B31

Sheet1 b3

 

[VoG]

Right click the tab of your form, select View Code and paste into the white space on the right

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "B31" Then Sheets("Sheet1").Range("B3").Value = Date
End Sub

then press ALT + Q to close the code window.