Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with Dates!
How do i automatically enter a date that does not change everyday like it
does with the now() function? -- DW |
#2
|
|||
|
|||
You can enter the date with CTRL+<semi-colon . It will not
update. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DWilliams" wrote in message ... How do i automatically enter a date that does not change everyday like it does with the now() function? -- DW |
#3
|
|||
|
|||
Thanks Chip for your response. My problems is i have my student file set up
to where it automatically enters a test score date once the test score is entered. however i have discovered the dates change every time i reopen the worksheet the following day the formula is: =IF(P25="","",NOW()) is there a way to have the date automatically enter and not change? "Chip Pearson" wrote: You can enter the date with CTRL+<semi-colon . It will not update. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DWilliams" wrote in message ... How do i automatically enter a date that does not change everyday like it does with the now() function? -- DW |
#4
|
|||
|
|||
Yes, with a simple macro. Rightclick the sheet tab, choose "view code",
paste this in the Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$C$1" Then Range("C1").Value = Now End Sub HTH. Best wishes Harald "DWilliams" skrev i melding ... Thanks Chip for your response. My problems is i have my student file set up to where it automatically enters a test score date once the test score is entered. however i have discovered the dates change every time i reopen the worksheet the following day the formula is: =IF(P25="","",NOW()) is there a way to have the date automatically enter and not change? "Chip Pearson" wrote: You can enter the date with CTRL+<semi-colon . It will not update. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DWilliams" wrote in message ... How do i automatically enter a date that does not change everyday like it does with the now() function? -- DW |
#5
|
|||
|
|||
Sounds that you need event code
Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("P1:P100")) Is Nothing Then Target.Offset(0, 1).Value = Format(Date, "dd mmm,yyyy") End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "DWilliams" wrote in message ... Thanks Chip for your response. My problems is i have my student file set up to where it automatically enters a test score date once the test score is entered. however i have discovered the dates change every time i reopen the worksheet the following day the formula is: =IF(P25="","",NOW()) is there a way to have the date automatically enter and not change? "Chip Pearson" wrote: You can enter the date with CTRL+<semi-colon . It will not update. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DWilliams" wrote in message ... How do i automatically enter a date that does not change everyday like it does with the now() function? -- DW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting Dates | Excel Worksheet Functions | |||
Excel not recognizing Dates properly. | Excel Discussion (Misc queries) | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |