PDA

View Full Version : Solved: How to stop date updating?



Paul C
07-04-2006, 10:52 PM
I have a sign in register with a date command button that inputs todays date when pressed, problem is how do i stop it from updating say yesterdays to todays date when opended? I need the dates not to update with the system.

Thanks

ALe
07-04-2006, 11:47 PM
Hi Paul, you working so much during these days!

Well, if you convert formula to value you stop updating

something likeRange("a1").value=range("a1").value

Paul C
07-05-2006, 12:24 AM
Hi ALe

Slowly getting there :thumb

The onlt problem i have now is the last active cell i input the date into using the command button still updates to the current system date when i open the workbook, all the rest are fine.

Here is the code i am using

Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Range("e6:e43").Value = Range("e6:e43").Value
Range("e30").End(xlUp).Offset(1, 0).FormulaR1C1 = "=TODAY()"
End Sub


Thanks

Paul

ALe
07-05-2006, 12:27 AM
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Range("e30").End(xlUp).Offset(1, 0).FormulaR1C1 = "=TODAY()"
Range("e6:e43").Value = Range("e6:e43").Value

End Sub

Paul C
07-05-2006, 12:41 AM
Your a star ALe, Thank you very much sir!